Row dependent sumif
Results 1 to 7 of 7

Thread: Row dependent sumif

  1. #1
    Board Regular
    Join Date
    Nov 2016
    Posts
    364
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Row dependent sumif

    Hi

    I'd like to create a formula that sums up data in one column only if a condition of data in another column is met.

    In the example below, the values in cells A2:A4 are 1, 0, and 1, respectively.
    In cells B2:B4 the values are 100 in each cell.

    I would like to create a formula in cell C2 that sums up the data in column B IF and the value in column A is NOT equal to zero.

    Has anyone done this before?

    TIA

    Change Numbers
    1 100
    0 100
    1 100

  2. #2
    Board Regular tyija1995's Avatar
    Join Date
    Feb 2019
    Posts
    648
    Post Thanks / Like
    Mentioned
    14 Post(s)
    Tagged
    4 Thread(s)

    Default Re: Row dependent sumif

    So in the sample data would you expect C2 to return 200?

    =SUMIF(A2:A4,1,B2:B4)

    Will achieve this.

    If you would like otherwise please let me know, as I am assuming this is what you mean(?)
    √-1 2³ ∑ π
    …And it was delicious!

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,976
    Post Thanks / Like
    Mentioned
    459 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Row dependent sumif

    For not equal to zero you can use
    =SUMIF(A:A,"<>0",B:B)
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  4. #4
    Board Regular
    Join Date
    Nov 2016
    Posts
    364
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Row dependent sumif

    Yes, that's correct. That's great!

    Thank you tyija1995
    .
    Last edited by Mr2017; Jul 8th, 2019 at 07:34 AM.

  5. #5
    Board Regular
    Join Date
    Nov 2016
    Posts
    364
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Row dependent sumif

    That's great!

    Thank you Fluff

  6. #6
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    26,976
    Post Thanks / Like
    Mentioned
    459 Post(s)
    Tagged
    45 Thread(s)

    Default Re: Row dependent sumif

    You're welcome & thanks for the feedback
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10

  7. #7
    Board Regular
    Join Date
    Nov 2016
    Posts
    364
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Row dependent sumif

    You're welcome.

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
  •