CountA Question

brucew · Mar 24th, 2002, 06:33 PM

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 · Mar 24th, 2002, 06:39 PM

Quote:

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 · Mar 24th, 2002, 06:49 PM

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 24th, 2002, 06:33 PM	#1
brucew New Member Join Date: Mar 2002 Posts: 4	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.

Mar 24th, 2002, 06:49 PM	#3
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	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