Sumifs with various criteria

I am using the following formula, but I am trying to determine if there is an easier way to do it, cause it is too time consuming

=SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A12,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A13,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!K:K,'Purchase Orders'!$B:$B,'04-14-14'!$A14,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A15,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A16,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A17,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A18,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A19,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A20,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A21,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A22,'Purchase Orders'!$E:$E,C$6)+SUMIFS('Purchase Orders'!$K:$K,'Purchase Orders'!$B:$B,'04-14-14'!$A23,'Purchase Orders'!$E:$E,C$6)

Basically I have a range of PO's (that are listed in a column) I would like it to sum if it has a specific item # which is listed in a row.

I tried a basic sum if with a range, but it did not work well. I kept getting 0.

PO SCREEN SHOT.PNG

Sorry. I have used the forum to lookup and review other post, but I have never posted.

PO LOOK UP.xlsx

So, like, first off, SUMIFS can accept 127 criteria/range pairs, so there's no need to break it up, you can do it all in one SUMIFS:

Please Login or Register  to view this content.

Like that.

Or you can clean it up by going to a SUMPRODUCT construction using OR-addition:

Please Login or Register  to view this content.

IF you want a shorter formula you're going to have to change the underlying logic, like, by feeding through a helper column using OR, for example.

I would love to change the format of the sheet, but some people are old school and want it in a specific format. UGH. I have a love hate with inherited spreadsheets.

Ford -- Thanks for the example, but it is only retrieving the data for one PO. I want it to put at the bottom the sum of that particular item # on all PO's listed in Column A, not just one.

I am trying to find the variance for all items from a specific supplier versus what was originally ordered. I am really thinking the format is going to have to be revamped.

Would I be better off using index and match as they want to see the total in c10