+ Reply to Thread
Results 1 to 4 of 4

SUMIFS statement needed to pull multiple data from the same column

  1. #1
    Registered User
    Join Date
    12-17-2014
    Location
    Mitchell
    MS-Off Ver
    2010
    Posts
    2

    SUMIFS statement needed to pull multiple data from the same column

    Hi.
    First post and I want to say right up front that I tried searching for what I want to do without any success.

    I have a column with two values that I want a total sum on. Basically, here is what I have:

    COLUMN B
    Lot Number

    COLUMN D
    Cost

    From Column B, I want any lot numbers of 1993 and 1455

    Column E has the corresponding costs for each lot

    Column B Column E
    1455 $2.00
    1455 $3.00
    1367 $2.00
    1909 $4.00
    1993 $5.00
    1455 $3.00
    1689 $1.00
    1367 $1.00
    1455 $4.00

    In my example, I want to pull the prices from 1455 and 1993. The total should be $17.00 if I added everything together correctly. That sum (along with the working formula) would go into cell G2.

    Here is what I have been playing with which returns $0.00

    =SUMIFS(E2:E39,B2:B39,"=1113",B2:B39,"=1114")

    I'm thinking I need an "AND" statement or something....

    Mike

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: SUMIFS statement needed to pull multiple data from the same column

    Hi, welcome to the forum

    Try this....
    =SUM(SUMIF($B$3:$B$11,{1455,1993},$E$3:$E$11))
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Registered User
    Join Date
    12-17-2014
    Location
    Mitchell
    MS-Off Ver
    2010
    Posts
    2

    Re: SUMIFS statement needed to pull multiple data from the same column

    That was quick.

    And it worked

    Thanks so much!!!!

    Mike

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: SUMIFS statement needed to pull multiple data from the same column

    Happy to help

+ 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] SUMIFS Statement needed?
    By cberger in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-01-2014, 08:26 PM
  2. Need to pull data from multiple columns only if value in column A
    By RogueOfDoE in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-28-2013, 03:32 PM
  3. Replies: 12
    Last Post: 01-31-2013, 03:30 PM
  4. [SOLVED] Pull data from same cell from multiple sheets into master column
    By incubi in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-09-2013, 04:42 PM
  5. Replies: 5
    Last Post: 11-06-2012, 07:17 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