Forum Discussion
Solved
IF Function Help
Hi, I am trying to use the IF function but the output says "#SPILL". May you help me let me know where I went wrong with the IF Function equation? Kindly see attached for "Raw Data" an...
AmyYang When you take your formula outside the table, you'll note that it creates a dynamic array.
And you can't use that inside a structured table. You could wrap the formula in SUM to return a single value.
Alternatively use SUMIFS
=SUMIFS(Table1[ASR (W) (Incidence per 100 000 Population)],Table1[Indication],[@Indication],Table1[Population],[@Country])
AmyYang When you take your formula outside the table, you'll note that it creates a dynamic array.
And you can't use that inside a structured table. You could wrap the formula in SUM to return a single value.
Alternatively use SUMIFS
=SUMIFS(Table1[ASR (W)
(Incidence per 100 000 Population)],Table1[Indication],[@Indication],Table1[Population],[@Country])
Dear Riny,
Understood, thanks so much for your explanation!
Regards,
Amy
Understood, thanks so much for your explanation!
Regards,
Amy