+ Reply to Thread
Results 1 to 6 of 6

SUMIFS to total product A and B

  1. #1
    Registered User
    Join Date
    12-22-2011
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    58

    SUMIFS to total product A and B

    Guten Tag!

    I have attached a spreadsheet. I have 4 products - A, B, C, and D, along with how many units of them were made.
    I have no problem automatically summing up "units made" for each individual product, however, I AM having trouble using SUMIFS to sum "units made" for both A and B in the same cell.

    =SUMIFS(units made column,product type column, can be A or B)

    Any ideas would be appreciated.
    Attached Files Attached Files

  2. #2
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,417

    Re: SUMIFS to total product A and B

    i do not know how to accomplish this with SUMIFS (in the fashion you have depicted), may be an expert can assist. with SUMPRODUCT, it is a breeze:

    in cell I3:

    =SUMPRODUCT(($A$2:$A$12="a")+($A$2:$A$12="b"),$B$2:$B$12)
    Last edited by icestationzbra; 05-26-2012 at 12:40 AM.
    - i.s.z -
    CSE, aka Array aka { }, formulae are confirmed with CONTROL+SHIFT+ENTER.
    Replace commas ( , ) with semicolons ( ; ) in formulae, if your locale setting demands.
    All good ideas are courtesy resources from this forum as well as others around the web.
    - e.o.m -

  3. #3
    Forum Expert dilipandey's Avatar
    Join Date
    12-05-2011
    Location
    Dubai, UAE
    MS-Off Ver
    1997 - 2016
    Posts
    8,191

    Re: SUMIFS to total product A and B

    Hi Mike,

    Why don't you combine both SumIFs for A and B to get the result as 254..

    Regards,
    DILIPandey

    <click on below 'star' if this helps>
    DILIPandey
    +91 9810929744
    dilipandey@gmail.com

  4. #4
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: SUMIFS to total product A and B

    Like this

    =SUM(SUMIF($A$2:$A$12,"A",$B$2:$B$12),SUMIF($A$2:$A$12,"B",$B$2:$B$12))
    and
    =SUM(SUMIF($A$2:$A$12,"C",$B$2:$B$12),SUMIF($A$2:$A$12,"D",$B$2:$B$12))

  5. #5
    Registered User
    Join Date
    12-22-2011
    Location
    Berlin, Germany
    MS-Off Ver
    Excel 2010
    Posts
    58

    Re: SUMIFS to total product A and B

    Thanks! That should work.

  6. #6
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: SUMIFS to total product A and B

    You're welcome. Thanks for the 'star tap'.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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