Results 1 to 7 of 7

SUMIFS to match array of Criteria

Threaded View

  1. #1
    Registered User
    Join Date
    06-21-2013
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    11

    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.
    Last edited by amazinglazers; 07-19-2013 at 06:20 AM. Reason: Amend to title; not clear.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 07-02-2017, 10:25 AM
  2. SUMIFS with Multiple Criteria and a Partial match
    By paulbeav in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 06-28-2013, 04:00 PM
  3. Replies: 4
    Last Post: 06-27-2012, 03:04 PM
  4. Replies: 5
    Last Post: 09-07-2011, 11:14 PM
  5. Replies: 1
    Last Post: 05-16-2011, 05:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1