+ Reply to Thread
Results 1 to 4 of 4

SUMIF for multiple rows

  1. #1
    Registered User
    Join Date
    05-28-2014
    Posts
    8

    SUMIF for multiple rows

    I have an e-commerce site, and my backend service (shopify) exports my orders into an excel format.

    I'm trying to add up the quantities of items sold in a particular state (TX). SUMIF formula seems like the straightforward solution, but the problem I'm running into is that for orders with multiple items, the state only appears once per order number.

    So in the example, the highlighted section is one order (order #1647). The person ordered 3 items, and lives in TX. I want to add these up, but the state only appears in the first row of that order.

    How can I adjust the formula to add up all the items from a certain state?

    Thanks in advance.
    Attached Images Attached Images

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIF for multiple rows

    Fill the empty cells. It's easy:

    http://contextures.com/xlDataEntry02.html
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    05-28-2014
    Posts
    8

    Re: SUMIF for multiple rows

    Quote Originally Posted by Tony Valko View Post
    Fill the empty cells. It's easy:

    http://contextures.com/xlDataEntry02.html
    Elegant and simple...thank you!

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: SUMIF for multiple rows

    You're welcome. Thanks for the feedback!


    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Using SUMIF across multiple rows
    By wvpersephone13 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2012, 01:12 PM
  2. Sumif on multiple matching rows
    By w1nta in forum Excel General
    Replies: 2
    Last Post: 05-07-2012, 09:35 PM
  3. Specify multiple rows for SUMIF range?
    By necht_angel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-17-2011, 04:15 AM
  4. How to use SUMIF with multiple rows of each instance?
    By paulishuku in forum Excel General
    Replies: 5
    Last Post: 06-14-2011, 09:50 PM
  5. Sum multiple rows (SUMIF?)
    By nougain in forum Excel General
    Replies: 3
    Last Post: 03-10-2007, 11:29 AM

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