Count random columns only if the value is greater than 0

[Janedb]

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?

[#2 · Accepted solution]

This problem was solved by using
=COUNTIF(J4,">0")+COUNTIF(L4,">0")+COUNTIF(O4,">0")+COUNTIF(R4,">0")

[#3]

Thanks for posting the solution.