Sumproduct by criteria, need help.

[ExcellNooob]

Hi all,
I have tables like this

And i need to sum all rows for the Item 1, where status are Ready.
Price and quantity is always different eaven for the same items, and somtimes the same items how more status, and i need to sum only ready items.
Please help. This is for my work.

Regards,

ExcelNooobs.

 

[AliGW]

=SUMIFS(D2:D7,F2:F7,"Item 1",H2:H7,"Ready")

 

[AlanY]

try

=SUMPRODUCT(D2:D7,(F2:F7="Item1")*(I2:I7="Ready"))

 

[ExcellNooob]

Its not working, there is no array for quantity? And can i put the whole range? Like d:d not from d1:d7?
Because we have a lot of items. AligW thanks on help, but its not working. :/

 

[RoryA]

You can use whole columns but it's not a good idea. Better to use either a large range, or a dynamic range or Table.

=SUMPRODUCT(D2:D1000,H2:H1000,(F2:F1000="Item1")*(I2:I1000="Ready"))
for example.

 

[AlanY]

try

=SUMPRODUCT(D2:D7,(F2:F7="Item1")*(I2:I7="Ready"))

try

=SUMPRODUCT(D2:D1000,(F2:F1000="Item1")*(j2:j1000="Ready"))

 

[ExcellNooob]

RoryA work like a charm, thank you very much. Thanks to other too. You make my life easyer now.
I use formula sumifs for summ all qty for some items by grades. All items have grade like a, b, c .. and i use this formula =SUMIFS(H:H,F:F,List!$B$1,G:G,List!S2,J:J,List!$D$1)
where h:h are sum range, f:f are first criteria range, after that go criteria, and second criteria range for grades, after that grades, and then third criteria range for status, and then status criteria. And formula work on first time, but then later do not update it self. I tray go to options, and there is marked to update automaticly formula. But this not happen. :/

 

[RoryA]

Do you have any circular references being shown in the status bar?

What are you changing that should change the formula result?

 

[ExcellNooob]

I put new items order, and on the other items change status. So its should not count it any more, because if items are shipped, they do not need to count that they are ready for shipment.