Forum Discussion
SUMIFS GIVES #VALUE
=SUMIFS('MASTER DATA'!$I$4:$AK$990,'MASTER DATA'!$H$4:$H$990,$H4,'MASTER DATA'!$I$3:$AK$3,I$3), Is there any error or mistake in the above formula?
From Microsoft herself:
The Criteria_range argument must contain the same number of rows and columns as the Sum_range argument.