Results 1 to 6 of 6

SUMIFS to total product A and B

Threaded View

Subject_Name_Here SUMIFS to total product A and... 05-25-2012, 11:18 PM
icestationzbra Re: SUMIFS to total product A... 05-26-2012, 12:34 AM
dilipandey Re: SUMIFS to total product A... 05-26-2012, 12:38 AM
Cutter Re: SUMIFS to total product A... 05-26-2012, 07:44 AM
Subject_Name_Here Re: SUMIFS to total product A... 05-26-2012, 11:27 AM
Cutter Re: SUMIFS to total product A... 05-26-2012, 11:56 AM
  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

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