SUM function returns 0

Copper Contributor

Hello, I am trying to compare columns to obtain a sum of values. This is my formula, the list are being read correctly but when I apply the SUM function it returns 0.






2 Replies


Your number values are text. SUM() ignores text.

Just convert text numbers to real numbers.




You attached the same screenshot twice..,



=SUMAR.SI.CONJUNTO(Table1[Tamaño Iniciativa]; Table1[Indique cuál superintendencia desarrollaria su Iniciativa]; [@Superintendencia]; Table1[Estado Initiciativa]; "Priorizado")