Mar 26 2024 11:56 AM
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.
Mar 26 2024 12:07 PM
Your number values are text. SUM() ignores text.
Just convert text numbers to real numbers.
Mar 26 2024 12:11 PM
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")