SUMIFS GIVES #VALUE

Question

=SUMIFS('MASTER DATA'!$I$4:$AK$990,'MASTER DATA'!$H$4:$H$990,$H4,'MASTER DATA'!$I$3:$AK$3,I$3),&nbsp;Is there any error or mistake in the above formula?

detlef_lewin · Answer

OLA123&nbsp;From Microsoft herself:The&nbsp;Criteria_range&nbsp;argument must contain the same number of rows and columns as the&nbsp;Sum_range&nbsp;argument.&nbsp;

hansvogelaar · Answer

OLA123&nbsp;
=SUMPRODUCT('MASTER DATA'!$I$4:$AK$990*('MASTER DATA'!$H$4:$H$990=$H4)*('MASTER DATA'!$I$3:$AK$3=I$3))

Forum Discussion

SUMIFS GIVES #VALUE

2 Replies

Resources