HI,
How do sumifs ranges in number corresponding to the month.
Data:
Document Date Plant Amount
01.04.2015 3100 5432.26
01.04.2015 3100 4203.28
01.04.2015 3100 915.61
01.04.2015 3100 22220.82
01.04.2015 3190 2655.81
01.04.2015 3190 254.67
01.04.2015 3700 8012.41
01.04.2015 3700 5521.92
01.04.2015 3700 8919.29
Req Format:
PLANT CODE
Month:Apr.15
A B C D
3100 3190 3700 58136.07
Am apply this formula
=SUMIFS('APRIL-15'!$C$2:$C$22294,'APRIL-15'!$B$2:$B$22294,REQFORMAT!$A3&REQFORMAT!B3&REQFORMAT!C3,'APRIL-15'!$A$2:$A$22294,">="&EOMONTH(REQFORMAT!$D$2,-1)+1,'APRIL-15'!$A$2:$A$22294,"<="&EOMONTH(REQFORMAT!$D$2,0))
value return is wrongly when range multiple.
please help me. file attached.
Bookmarks