SUM function returns 0

Question

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.&nbsp;&nbsp;&nbsp;

detlef_lewin · Answer

Edwin_AC&nbsp;Your number values are text. SUM() ignores text.Just convert text numbers to real numbers.&nbsp;&nbsp;

hansvogelaar · Answer

Edwin_AC&nbsp;
You attached the same screenshot twice..,
Try
&nbsp;
=SUMAR.SI.CONJUNTO(Table1[Tamaño Iniciativa]; Table1[Indique cuál superintendencia desarrollaria su Iniciativa]; [@Superintendencia]; Table1[Estado Initiciativa]; "Priorizado")

Forum Discussion

SUM function returns 0

Share