Forum Discussion
Solved
Count random columns only if the value is greater than 0
Hi, I am trying to calculate events and I use the =COUNTA(J4,L4,O4,R4). The problem with this is that it also counts columns as 1 if there is a formula in even if the total is 0. How can I fix this?
- This problem was solved by using
=COUNTIF(J4,">0")+COUNTIF(L4,">0")+COUNTIF(O4,">0")+COUNTIF(R4,">0")
