counting the cells ignoring zero values

  • Thread starter Thread starter awais
  • Start date Start date
CountIF. http://office.microsoft.com/en-us/excel/HP052090291033.aspx

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



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

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
 
Just to add:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Average problem 1
formula for countIf with two conditions 2
Count cells with numbers and ignore cells with errors 6
Formula that sums/counts across worksheets with variable reference 1
How do I get 0 (zero) to register as a value as opposed to blank c 4
Using COUNTA and excluding formulas that gives zero or blank cells 3
Ignoring Text in a formula 2
How to count the occurrence? 3

Back
Top