Function to count cells that are not empty?

  • Thread starter Thread starter Tech.Zoan
  • Start date Start date
T

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
 
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
 
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
 
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 -
 
Back
Top