Forum Discussion
Solved
Countif function
=COUNTIFS(D3,F3,H3,J3,L3,N3,P3,">0")
Tried writing this formula but it will calculate as 0 and not count the individual cells listed if their number is greater than 0.
My cells are specific ...
Hi Jessica,
COUNTIFS will not work in this case!
You should use this formula instead:
=(D3>0)+(F3>0)+(H3>0)+(J3>0)+(L3>0)+(N3>0)+(P3>0)
Hope that helps
Hi Jessica,
COUNTIFS will not work in this case!
You should use this formula instead:
=(D3>0)+(F3>0)+(H3>0)+(J3>0)+(L3>0)+(N3>0)+(P3>0)
Hope that helps
This worked best for me and it was simple enough that I was able to adjust the formula to other calculations needed for those same cells.
Thank you very much!