I need a formula to count only cells that have a value greater than 0. Is there such a formula?
G Guest Nov 20, 2003 #1 I need a formula to count only cells that have a value greater than 0. Is there such a formula?
A Alan Nov 20, 2003 #2 =COUNTIF(A1:A20,">"&0) Mister14 said: I need a formula to count only cells that have a value greater than 0. Is Click to expand... there such a formula?
=COUNTIF(A1:A20,">"&0) Mister14 said: I need a formula to count only cells that have a value greater than 0. Is Click to expand... there such a formula?
C Chip Pearson Nov 20, 2003 #3 Try the following. Adjust the range to meet your needs. =COUNTIF(A1:A100,">0") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com Mister14 said: I need a formula to count only cells that have a value greater than 0. Is Click to expand... there such a formula?
Try the following. Adjust the range to meet your needs. =COUNTIF(A1:A100,">0") -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com Mister14 said: I need a formula to count only cells that have a value greater than 0. Is Click to expand... there such a formula?