Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Sum If

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Location
    Los Angeles, CA
    Posts
    752
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    OK, here is the info. Its better if I show you and then explain.

    Column A, Column B, Column C
    10L, data, data
    5I, data, data
    6I, data, data
    5I, data, data
    10L, data, data
    etc., data, data
    Sub Total for each of the 3 variable in column A

    Column A, Column B, Column C
    10L, data, data
    5I, data, data
    10L, data, data
    5I, data, data
    6I, data, data
    10L, data, data
    etc., data, data
    Sub Total for each of the 3 variable in column A

    Grand Total

    In the sub total, I only want the numbers to add if they match for example only those that have 5I in column A, etc. And then the grand total to all the subtotals for 5I,6I and 10I.

    Can someone please help me, with a formula.

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,034
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    =SUMIF(A2:A100,"5L",B2:B100)

    would total the data in B that correspond to a "5L" in A.

    Aladin

Some videos you may like

User Tag List

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
  •