hello!
I need to count only the data> 0 entered in several columns. How do I put the condition “> 0” in this expression?
= COUNT (LIST ([P1], [P2], [P3], [P4], [P5], [P6], [P7], [P8], [P9], [P10], [P11], [ P12], [P13], [P14], [P15]))
thanks!
@Ballve_Rosario_Maria You’re going to need to do something like this:
IF([P1] > 0, 1, 0) + IF([P2] > 0, 1, 0) + … + IF([P15] > 0, 1, 0)
Generally speaking, having a lot of columns like that is a bad idea. It’d be better if you created another table that has a reference column, then you can use a COUNT(SELECT(…)) expression.
IFS([P1]>0,1)+… would help a little
thank you very much
User | Count |
---|---|
43 | |
28 | |
24 | |
21 | |
13 |