CountA Question

[brucew]

I have the following set of data:
A B C D E F G
1 a e t q t

What I would like to do is output a counta in cell A1 using variables. I would also like this counta to dynamically update as I delete or add to the cells. I have tried to add just a string variable into counta but it does not work. Any suggestions would be greatly appreciated.

 

[Aladin Akyurek]

On 2002-03-24 17:33, brucew wrote:
I have the following set of data:
A B C D E F G
1 a e t q t

What I would like to do is output a counta in cell A1 using variables. I would also like this counta to dynamically update as I delete or add to the cells. I have tried to add just a string variable into counta but it does not work. Any suggestions would be greatly appreciated.

Care to elaborate a bit more? COUNTA just counts every non-empty cell in the range it's given. Are you trying to variablize where its range ends?

 

[Dave Hawley]

Hi Bruce

Do you mean COUNTIF? If so just use:

=COUNTIF(MyDynaRange,B1)
Where B1 could also contain a list from the Validation feature found under Data. The named range MyDynaRange is a dynamic named range that expands/contracts automatically as you you add/delete to/from the range. I have many diferent types of these to be found here:
http://www.ozgrid.com/Excel/DynamicRanges.htm