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!
