# Sum If Array Formula with Two Criteria

#### MB161

##### Board Regular
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?

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

### Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
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))

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))

Replies
3
Views
392
Replies
4
Views
382
Replies
2
Views
80
Replies
7
Views
696
Replies
11
Views
656

1,206,831
Messages
6,075,118
Members
446,123
Latest member
junkyardforme

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back