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