+ Reply to Thread
Results 1 to 2 of 2

sumifs when criteria is met...sum up to total

  1. #1
    Registered User
    Join Date
    12-05-2013
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    40

    sumifs when criteria is met...sum up to total

    Hi,
    need assistance on this code
    =SUMIFS(rway_bom!$A$1:$A$50,"TRAY",rway_bom!$B$1:$B$50,"straight",rway_bom!$E$1:$E$50,"8"=sum(rway_bom!$D$1:$D$50))

    after all the criteria is met i want to add the total
    rway_bom (data sheet)
    sheet 1 is where i want to total to show

    (rway_bom)
    a1 to a50 looks for TRAY (criteria 1)
    b1 to b50 looks for straight (criteria 2)
    e1 to e50 looks for 8 (criteria 3)
    if all is met
    d1 to d50 add all for total to be shown on sheet 1

    Help

  2. #2
    Forum Expert newdoverman's Avatar
    Join Date
    02-07-2013
    Location
    Port Dover, Ontario, Canada
    MS-Off Ver
    2010
    Posts
    10,330

    Re: sumifs when criteria is met...sum up to total

    This should do it:

    Formula: copy to clipboard
    Please Login or Register  to view this content.


    You can also use absolute references and cells to hold the criteria....I used C1 to C3 for the criteria in this formula that does exactly the same thing as the first formula except that the ranges are absolute and the criteria are in cells so that different criteria can be used without going into the formula to make changes.

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by newdoverman; 01-09-2014 at 12:25 PM.
    <---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.
    Ron W

+ 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 Sumifs (Or other Total Functions)
    By dgamboa9999 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-03-2013, 03:14 AM
  2. Replies: 3
    Last Post: 11-21-2012, 04:57 PM
  3. [SOLVED] SUMIFS to total product A and B
    By Subject_Name_Here in forum Excel General
    Replies: 5
    Last Post: 05-26-2012, 11:56 AM
  4. Replies: 5
    Last Post: 09-07-2011, 11:14 PM
  5. Replies: 1
    Last Post: 05-16-2011, 05:00 PM

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