Formula Help

[Travisallen2007]

I am needing help with a formula if anyone has time:

I am needing it to count the number of cells that have an amount greater than 0 but cannot use count as the field has 0 if its 0.

Would be like:
=count(b15:h15) if x>0.00

Cell b15 - 0
Cell c15 - 7
cell c16 - 15
cell c17 - 0
cell c18 - 0
total count - 2

not sure how to get that to work.

 

[CA_Punit]

Is your cells Non Contiguous. I mean You have data in cell B15 , C15:C18.

Can we select cell from B15:C18. If Yes then =COUNTIF(B15:C18,">0")

If it is non Contiguous and have values in B16:B18 then try this =COUNTIF(B15,">0")+COUNTIF(C15:C18,">0")

 

[Travisallen2007]

Thank you!! That worked perfect!