
Originally Posted by
SLWright
I managed to get this to work by changing the value in K3 from *00008 to 8, and the formulas to:
=SUMIFS(INDIRECT(I$22&"!F:F"),INDIRECT(I$22&"!A:A"),Cover!$K$3,INDIRECT(I$22&"!E:E"),">="&IF(MONTH($D34)=1,DATE(I$22+1,1,1),DATE(I$22,MONTH($D34),1)),INDIRECT(I$22&"!E:E"),"<="&IF(MONTH($D34)=1,EOMONTH(DATE(I$22+1,1,1),0),EOMONTH(DATE(I$22,MONTH($D34),1),0)),INDIRECT(I$22&"!C:C"),"NON-ASSOCIATE THEFT")
=SUMIFS(INDIRECT(I$22&"!G:G"),INDIRECT(I$22&"!A:A"),Cover!$K$3,INDIRECT(I$22&"!E:E"),">="&IF(MONTH($D34)=1,DATE(I$22+1,1,1),DATE(I$22,MONTH($D34),1)),INDIRECT(I$22&"!E:E"),"<="&IF(MONTH($D34)=1,EOMONTH(DATE(I$22+1,1,1),0),EOMONTH(DATE(I$22,MONTH($D34),1),0)),INDIRECT(I$22&"!C:C"),"NON-ASSOCIATE THEFT")
in both cases, change !D:D to !A:A and remove the &"*" after Cover!$K$3
Bookmarks