Formula needed to calculate monthly sales volume from one sheet to another based on dates

WS attached

Sheet ‘STATS’ I15:I26 is where the monthly sales volume needs to appear based on the months in adjacent J15:J26

Sales volume to be pulled from ‘SALES’ M6”M505 against dates in ‘SALES’ N6:N505

Thanks

You can put this formula in cell I15 of the STATS sheet:

=SUMIFS(SALES!$M$6:$M$550,SALES!$N$6:$N$550,">="&DATEVALUE(1&J15&J$14),SALES!$N$6:$N$550,"<="&EOMONTH(DATEVALUE(1&J15&J$14),0))

then copy down to I26.

Hope this helps.

Pete

Hi,

What I did was using an array, but I manually change the MONTH to (1-12).
The formula I used was this:

=SUM(IF(MONTH(SALES!$N$6:$N$500)=1,SALES!$M$6:M$500,0)) > January

If you use this formula, do not forget to enter (SHFT + CTRL + ENTER) to use the array.

Hope this helps.

Regards,

thanks, i appreciate it

You're welcome - thanks for the rep.

Pete