Sum If Array Formula with Two Criteria

[MB161]

Afternoon,

I am trying to look up and sum 7 days worth of sales data, from another table, based on the onsale date in my first table. The formula below works when the second criteria is removed by not when it's added. What am I missing?

 {=SUM(IF(AND('Sales'!$C$3:$C$548>=K4,'EPoS Sales'!$C$3:$C$548<=(K4+6)),'Sales'!$J$3:$J$548,0))}

Thanks in advance!

 

[Andrew Poulsom]

Does this work for you?

=SUM(IF((('Sales'!$C$3:$C$548>=K4)*('EPoS Sales'!$C$3:$C$548<=(K4+6))),'Sales'!$J$3:$J$548,0))

 

[MB161]

It does. Thank you so much!

Does this work for you?

=SUM(IF((('Sales'!$C$3:$C$548>=K4)*('EPoS Sales'!$C$3:$C$548<=(K4+6))),'Sales'!$J$3:$J$548,0))