Countif syntax help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Paul Hyett - 04 Nov 2007 09:21 GMT

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

Signature

Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Reply to this Message

www.exciter.gr: Custom Excel Applications! - 04 Nov 2007 10:07 GMT

Just use the COUNTA function:

=COUNTA(your_range)

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

> 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.
[quoted text clipped - 4 lines]
> --
> Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Reply to this Message

Paul Hyett - 04 Nov 2007 19:40 GMT

In microsoft.public.excel on Sun, 4 Nov 2007, "www.exciter.gr: Custom
Excel Applications!" <mk@exciter.gr> wrote :

>Just use the COUNTA function:
>
>=COUNTA(your_range)

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

Signature

Paul Hyett, Cheltenham (change 'invalid83261' to 'blueyonder' to email me)

Reply to this Message