i want to count number of cells that contain some numeric value other than zero.
A awais Jun 14, 2008 #1 i want to count number of cells that contain some numeric value other than zero.
B Ben M. Schorr - MVP (OneNote) Jun 14, 2008 #2 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
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
D Dave Peterson Jun 14, 2008 #3 Just to add: =COUNTIF(A1:A30,"<>0") or =COUNTIF(A1:A30,"<>"&0) or if B1 held 0: =COUNTIF(A1:A30,"<>"&b1)
Just to add: =COUNTIF(A1:A30,"<>0") or =COUNTIF(A1:A30,"<>"&0) or if B1 held 0: =COUNTIF(A1:A30,"<>"&b1)
