Row dependent sumif

[Mr2017]

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

[TABLE="width: 128"]
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"]Change[/TD]
[TD="width: 64"]Numbers[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]0[/TD]
[TD="align: right"]100[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD="align: right"]100[/TD]
[/TR]
</tbody>[/TABLE]

 

[tyija1995]

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(?)

 

[Fluff]

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

 

[Mr2017]

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

Thank you tyija1995

.

 

[Mr2017]

That's great!

Thank you Fluff

 

[Fluff]

You're welcome & thanks for the feedback

 

[Mr2017]

You're welcome.