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
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>
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 |
<colgroup><col width="64" span="2" style="width:48pt"> </colgroup><tbody>
</tbody>