Using your posted workbook
this formula, copied down, returns the sum for a particular month for up to 3 plant codes (listed in columns A through C)
E3: =SUMPRODUCT(SUMIFS('APRIL-15'!$C$2:$C$22294
,'APRIL-15'!$B$2:$B$22294,REQFORMAT!$A3:C3
,'APRIL-15'!$A$2:$A$22294,">"&EOMONTH(REQFORMAT!$D$2,-1)
,'APRIL-15'!$A$2:$A$22294,"<="&EOMONTH(REQFORMAT!$D$2,0)))
This alternative formula returns the same values:
E3: =SUMPRODUCT((TEXT('APRIL-15'!$A$2:$A$22296,"YYYYMM")=TEXT($D$2,"YYYYMM"))
*('APRIL-15'!$B$2:$B$22296=REQFORMAT!A3:C3)*'APRIL-15'!$C$2:$C$22296)
Is that something you can work with?
Bookmarks