sumif, 90 days, multiple items

[stanchy]

I am trying to sum the total quantity of orders, between 6 part numbers, over the past 90 days.

I have come up with a 90 day sumif for a full column
=SUMIFS(C6:C20,A6:A20,">="&A2,A6:A20,"<="&A1)

A1 =now
A2 =now(-90)
A6:20 = Date
C6:20 = Value

It works great for a table with only 1 type of item, and a full column


Now I need to use the same type of formula, but over a bigger spreadsheet

Still need 90 day history
But to pick out 6 part numbers out of 100

How can I search for part number= 1 or 2 or 3 or 4 or 5 or 6 between dates now and now(-90) and sum the total?

Can I reuse the sumifs I did above, but replace the c6:c20 with another formula?
or am i going about this the wrong way?

Its friday... and I have an hour left in my work week
soooo hope everyone has a great weekend!

Thanks!

 

[Saba Sabaratnam]

Use the array formula by pressing Shift + Control + Enter

=SUM(SUMIFS(C6:C20,A6:A20,">="&A2,A6:A20,"<="&A1,B6:B20,"="&E11:E12))

I assume that B6:B20 has the list of parts and E11:E12 has the parts that you want to add total for. You can expand E11:E12 to include list of 6 parts instead of two that I used in the example.

Let me know how you go.

Enjoy your weekend. Here my weekend already started and got Monday as public holiday.

 

[jtakw]

Hi,

You can add a condition in your SUMIFS formula for each "part number", if you have 6 part numbers, you'll need 6 SUMIFS formulas, then SUM all the SUMIFS, or you can use 1 SUMPRODUCT formula.