Function to count cells that are not empty?

[Tech.Zoan]

Is there a function that will return a value showing me how many cells
within a specified range are not empty?

For example... say I have a column called Profit Amount and there's 10
amounts shown within a range of 40 rows. Is there a function that
will look at all 40 cells in that column and return a value telling me
there's only 10 cells that have an amount in them?

TIA

 

[Pete_UK]

Try this:

=COUNTIF(A1:A40,"<>"&"")

Hope this helps.

Pete

 

[Ron Rosenfeld]

Is there a function that will return a value showing me how many cells
within a specified range are not empty?

For example... say I have a column called Profit Amount and there's 10
amounts shown within a range of 40 rows. Is there a function that
will look at all 40 cells in that column and return a value telling me
there's only 10 cells that have an amount in them?

TIA

If all of the values of interest are numbers, then you can use the COUNT
worksheet function
--ron

 

[Sandy Mann]

Pete,

Wont just:

=COUNTIF(A1:A40,"<>")

suffice?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


Try this:

=COUNTIF(A1:A40,"<>"&"")

Hope this helps.

Pete

 

[RagDyer]

Try this:

=COUNTA(A1:A40)

 

[Pete_UK]

I wasn't sure, Sandy.

Pete

Pete,

Wont just:

=COUNTIF(A1:A40,"<>")

suffice?

--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk


Try this:

=COUNTIF(A1:A40,"<>"&"")

Hope this helps.

Pete





- Show quoted text -

 

[Tech.Zoan]

Thank you both! That worked perfectly!

Try this:

=COUNTA(A1:A40)

 

[RagDyer]

Appreciate the feed-back.