MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Counting cells


Posted by Andy Gee on February 07, 2002 4:05 PM

Is there any way in which I can count the number of times a cell containing text appears in an array?
Any help would be great!

=COUNT(A1:A10) Results in a 0 although text in in three cells.

I need it to result as 3


Posted by Aladin Akyurek on February 07, 2002 4:06 PM

Use COUNTA instead. [NT]

Posted by Andy Gee on February 07, 2002 4:09 PM

Re: Use COUNTA instead. Thanks!

Thanks! I'm sure I tried that but obviously did it wrong! Toooo many coffies!