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?
=SUMPRODUCT('MASTER DATA'!$I$4:$AK$990*('MASTER DATA'!$H$4:$H$990=$H4)*('MASTER DATA'!$I$3:$AK$3=I$3))