counting the cells ignoring zero values
 

i want to count number of cells that contain some numeric value other than
zero.

counting the cells ignoring zero values
 

CountIF. http://office.microsoft.com/en-us/ex...090291033.aspx

--
-Ben-
Ben M. Schorr, MVP
Roland Schorr & Tower
http://www.rolandschorr.com
http://www.officeforlawyers.com



"awais" wrote in message
:

i want to count number of cells that contain some numeric value other than
zero.

No virus found in this incoming message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.3.0/1502 - Release Date: 6/13/2008 7:25 PM

No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.524 / Virus Database: 270.3.0/1502 - Release Date:
6/13/2008 7:25 PM

counting the cells ignoring zero values
 

Just to add:

=COUNTIF(A1:A30,"<0")
or
=COUNTIF(A1:A30,"<"&0)
or if B1 held 0:
=COUNTIF(A1:A30,"<"&b1)



awais wrote:

i want to count number of cells that contain some numeric value other than
zero.

--

Dave Peterson