Entry Count

[ExcelRoy]

Hi,

I am looking for a formula to count the amount of entries within C13:C512

There is a formula in each cell within this range which displays "" if nothing found

I have tried =COUNTA(C13:C512) but this results in 500, even though there is only 44 entries displayed

Many thanks for any help

 

[Eric W]

Try:

=SUMPRODUCT(--(C13:C512<>""))

 

[Fluff]

One option is
=COUNTA(C2:C32)-COUNTBLANK(C2:C32)

 

[Tetra201]

Or

=ROWS(C13:C512)-COUNTIF(C13:C512,"")

 

[ExcelRoy]

Wow many thanks peoples, I went with Eric's solution

Many thanks for the replies

 

[Fluff]

You're welcome & thanks for the feedback