Countif syntax help

[Paul Hyett]

I have a range of cells that I want to count only if they are not empty,
regardless of whether the contents are numbers, text or formulas.

Since there is no 'NOTBLANK' function, how would I go about doing this?

TIA

 

[www.exciter.gr: Custom Excel Applications!]

Just use the COUNTA function:

=COUNTA(your_range)

http://www.exciter.gr
Custom Excel Applications and Functions!

 

[Paul Hyett]

In microsoft.public.excel on Sun, 4 Nov 2007, "www.exciter.gr: Custom

Just use the COUNTA function:

=COUNTA(your_range)

Thanks - didn't think it'd be that simple.