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.
Bookmarks