Function to count cells that are not empty?

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
 
R

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
Click to expand...

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

Sandy Mann

Pete,

Wont just:

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

suffice?

--
Regards,

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk


Try this:

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

Hope this helps.

Pete
 
P

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk


Try this:

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

Hope this helps.

Pete





- Show quoted text -
Click to expand...
 
Top