Travisallen2007
New Member
- Joined
- Jan 21, 2018
- Messages
- 30
- Office Version
- 365
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.
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.