SUMIFS to match array of Criteria

I am trying to use SUMIFS to return the sum of a revenue column if the adjacent column contains one of two possible values.

So let's say column A contains 5 lines of revenue figures.

Column B contains the status of a sales order that that revenue applies to. The order status can be either: Processing, Complete, Cancelled or Closed.

REVENUE	STATUS
22.30	Complete
19.99	Closed
100	Complete
56.50	Complete
39.25	Cancelled

How do I use the SUMIFS formula to get the total of revenue for the two orders that equal 'Cancelled' and 'Closed', so in this case, I want to see the figure 59.24.

I tried embedding an 'OR' statement, but that didn't seem to work.

Note that I'm using the SUMIFS formula because more criteria need to be added later, such as a date range.

Try this...

Formula:

Please Login or Register  to view this content.

Somehow its true.. I thonk.. You are using only SumIF section.. not the outer SUM..

Try to use the above with Ctrl + Shift + Enter.. but i hope its not required..

still try one more approach.

Formula:

Please Login or Register  to view this content.

Thanks for the feedback & Rep..