# Thread: Row dependent sumif Thanks:  2 Post #5305924 (1)Post #5305919 (1) Likes:  2 Post #5305924 (1)Post #5305919 (1)

1. ## 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. ## 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(?)

3. ## Re: Row dependent sumif

For not equal to zero you can use
=SUMIF(A:A,"<>0",B:B)

4. ## Re: Row dependent sumif

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

Thank you tyija1995
.

5. ## Re: Row dependent sumif

That's great!

Thank you Fluff

6. ## Re: Row dependent sumif

You're welcome & thanks for the feedback

7. ## Re: Row dependent sumif

You're welcome.

## User Tag List

#### Posting Permissions

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