hello! I need to count only the data> 0 ente...

[Ballve_Rosario_]

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!

[tony1]

@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.

[tony1]

https://help.appsheet.com/data/references/references-between-tables

[Aleksi_Alkio]

IFS([P1]>0,1)+… would help a little

[Ballve_Rosario_]

thank you very much