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.

 

Edwin_AC_1-1711475870106.png

 

Edwin_AC_0-1711475840982.png

 

2 Replies

@Edwin_AC 

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

Just convert text numbers to real numbers.

 

 

@Edwin_AC 

You attached the same screenshot twice..,

Try

 

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