+ Reply to Thread
Results 1 to 6 of 6

Sum and If criteria help

  1. #1
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    Sum and If criteria help

    Hello,

    I thought this was going to be easy, but stumped and looking for help.
    Please refer to my attachment, here's what I want to do.

    At cell L3, I want to sum column AC if K3 cells equals "Front Load" under Column AH and if the month under column AI equals L2.

    ThanksSumDemo.xlsx
    ==========
    Bigroo1958
    Austin, Texas
    ==========

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,077

    Re: Sum and If criteria help

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

    or change the existing formula into an arrayformula by closing the formula with [enter] while pressing [ctrl] and [shift] together.
    Using the sumifs function is recommended (faster).
    BTWI the result = 0 which is correct.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

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

    Re: Sum and If criteria help

    The SUMIFS formula can be copied down and across to fill in the rest of the chart.

    The formula shown is the same as Tsjallie's formula with the elements in a different order.

    K
    L
    M
    N
    O
    P
    Q
    R
    S
    T
    U
    V
    W
    1
    2
    Jan
    Feb
    Mar
    Apr
    May
    Jun
    Jul
    Aug
    Sep
    Oct
    Nov
    Dec
    3
    Front Load
    0
    838
    905
    1,745
    846
    0
    905
    0
    898
    805
    0
    989
    4
    Side Load
    0
    0
    0
    0
    0
    805
    616
    0
    0
    0
    0
    0
    5
    6
    =SUMIFS($AC$10:$AC$28,$AH$10:$AH$28,$K3,$AI$10:$AI$28,L$2)
    Last edited by newdoverman; 07-30-2015 at 05:20 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

  4. #4
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    Re: Sum and If criteria help

    Tsjallie,

    Wow, nice work, this works nicely, thanks for the quick reply!
    This is going to help me move forward with my dashboard scorecard.

    Thanks again!

  5. #5
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    Re: Sum and If criteria help

    Tsjallie,

    Wow, nice work, this works nicely, thanks for the quick reply!
    This is going to help me move forward with my dashboard scorecard.

    Thanks again!

  6. #6
    Forum Contributor
    Join Date
    11-27-2009
    Location
    Austin, Texas
    MS-Off Ver
    Excel 2013 & 2016
    Posts
    409

    Re: Sum and If criteria help

    Thank Newdoverman for the reply, all is good.

    Thanks

+ 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] Count of rows in an array that meet criteria in column 2 and different criteria in column3
    By reynoldslarry in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-09-2013, 01:51 AM
  2. Replies: 1
    Last Post: 09-03-2013, 07:41 PM
  3. [SOLVED] Find a number closest to 30 in a range with one more criteria (criteria includes text)
    By Sarangsood in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-22-2013, 01:16 PM
  4. Count statement wtih multiple criteria only showing results for one criteria
    By uhlabomber in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-17-2013, 02:47 PM
  5. Replies: 4
    Last Post: 01-08-2013, 12:37 PM
  6. [SOLVED] create drop down box to select multiple criteria and link macro to each criteria
    By anand_erin in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 11-03-2012, 06:35 PM
  7. Replies: 2
    Last Post: 10-05-2011, 12:43 PM
  8. MACROS: Sort by multiple criteria - Create tabs based off of criteria
    By svineyard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-21-2009, 10:48 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