SUMIF Formulas needed for date references

[teamexcel777]

This is hard without being able to upload a WS but here it goes.

I basically need a 2 SUMIFS formula

I have 2 worksheets; SALES & STATS

On STATS M17:M28 starting on M17 I have al 12 months of the year listed as 1/1/2017, 2/1/2017, etc.

on STATS W17:W28 is where the formula is needed.

STATS W17:W28 is suppose to show the sum of SALES O6:O1005 and distributed into the proper months adjacent on M17:M28 based on the dates entered into SALES P6:P1005 only if the criteria in SALES I6:I1005 = "CL" and SALES E6:E1005 = "B"

Same formula needed for Y17:Y28 with the exception of E6:E1005 = "S"

 

[Marcelo Branco]

See if this does what you want

Formula in W17 copied down
=SUMIFS(SALES!$O$6:$O$1005,SALES!$P$6:$P$1005,">="&M17,SALES!$P$6:$P$1005,"<="&EOMONTH(M17,0),SALES!$I$6:$I$1005,"CL",SALES!$E$6:$E$1005,"B")

Hope this helps

M.

 

[teamexcel777]

works great, thanks. I do have one more simular one thats simple. I will post new thread as "Simple SUMIF Needed"