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...
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")