SOLVED

Count random columns only if the value is greater than 0

%3CLINGO-SUB%20id%3D%22lingo-sub-2195131%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20random%20columns%20only%20if%20the%20value%20is%20greater%20than%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2195131%22%20slang%3D%22en-US%22%3EThis%20problem%20was%20solved%20by%20using%3CBR%20%2F%3E%3DCOUNTIF(J4%2C%22%26gt%3B0%22)%2BCOUNTIF(L4%2C%22%26gt%3B0%22)%2BCOUNTIF(O4%2C%22%26gt%3B0%22)%2BCOUNTIF(R4%2C%22%26gt%3B0%22)%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2208633%22%20slang%3D%22en-US%22%3ERe%3A%20Count%20random%20columns%20only%20if%20the%20value%20is%20greater%20than%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2208633%22%20slang%3D%22en-US%22%3EThanks%20for%20posting%20the%20solution.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2195066%22%20slang%3D%22en-US%22%3ECount%20random%20columns%20only%20if%20the%20value%20is%20greater%20than%200%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2195066%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20calculate%20events%20and%20I%20use%20the%20%3DCOUNTA(J4%2CL4%2CO4%2CR4).%26nbsp%3BThe%20problem%20with%20this%20is%20that%20it%20also%20counts%20columns%20as%201%20if%20there%20is%20a%20formula%20in%20even%20if%20the%20total%20is%200.%20How%20can%20I%20fix%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2195066%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

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 Replies
best response confirmed by Janedb (Contributor)
Solution
This problem was solved by using
=COUNTIF(J4,">0")+COUNTIF(L4,">0")+COUNTIF(O4,">0")+COUNTIF(R4,">0")
Thanks for posting the solution.