Oops, far too complex, try

=SUMPRODUCT(--(C3:C20<""))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Bob Phillips" wrote in message
...
Wellie,

Try this formula

=SUMPRODUCT(--ROWS((C3:C20)))-SUMPRODUCT((--(ISBLANK((C3:C20)))))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Wellie" wrote in message
...
I have a range of cell e.g. (C3:C20). I need to count #
of cells that users have entered any data.

Is the following worksheet function the correct one ?

=@countif(C3:C20),"")

If each cell from C3:C20 is blank, I expect it returns 0.
If I enter data in C5, C7 & C9, I expect it returns 3.

If not, what function should I use, please advise.

Thanks again for any help.