Results 1 to 3 of 3

Thread: Sum Formula with Criteria/Match
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2018
    Posts
    109
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Sum Formula with Criteria/Match

    Hello,

    Looking for help with a formula.

    I've got a spreadsheet that is just names and some numbers next to them. The names show up multiple times so I need the formula to look at each name, pull the number next to it, and sum all the numbers today.

    In the example below -- formula should see Don and be able to pull the total of 15 from all the cells.

    E.G.

    A B
    Don 5
    Jon 3
    Brad 3
    Don 8
    Don 2

  2. #2
    MrExcel MVP Eric W's Avatar
    Join Date
    Aug 2015
    Location
    Bountiful, UT
    Posts
    8,639
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    5 Thread(s)

    Default Re: Sum Formula with Criteria/Match

    Try:

    =SUMIF(A:A,"Don",B:B)
    Cheers,
    Eric

    When you eliminate the impossible, whatever remains, however improbable, must be the truth.

    -Posting guidelines, forum rules, terms of use, FAQs, BB codes, See how to search the forum
    -Post a screen shot with the HTML Maker

  3. #3
    Board Regular DanteAmor's Avatar
    Join Date
    Dec 2018
    Location
    México
    Posts
    6,208
    Post Thanks / Like
    Mentioned
    68 Post(s)
    Tagged
    14 Thread(s)

    Default Re: Sum Formula with Criteria/Match

    You can create a pivot table and get all totals by name.

    Regards Dante Amor

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •