Forum Discussion
Dynamic Array output not producing.
Above is the table I have created. I am trying to apply a formula "=SUM(Tracking[Amount] * (Tracking[Type] = "Expenses"))" in the selected cell. Which should produce output of 1350. But I am getting only 1200 which is only row specific (In second row of type Expenses is there). I did some reading and I found that Dynamic array output might be the problem. Could you please help me here?
2 Replies
Does it help if you confirm the formula by pressing Ctrl+Shift+Enter?
Alternatively, use
=SUMPRODUCT(Tracking[Amount] * (Tracking[Type] = "Expenses"))
or
=SUMIFS(Tracking[Amount], Tracking[Type], "Expenses")
Sahil_Ahmed Should work, provided that the second "Expenses" row indeed contains "Expenses" in the Type column. If you have, for instance "Expenses " (with a trailing space) it will not include the value for that row.
