Here's a challenge:
I'd like to sum the differences between two columns (B-A) but only for those rows where column B's value is greater than Column A's:
<tbody>
</tbody>
So my desired formula would produce '5' for this array, summing the difference for rows 3 and 4 because they are the ones that satisfy the criteria.
I can't make 'sumif' work for me b/c I don't know how to make it seek a neighboring column for its criteria. I have a spreadsheet with hundreds of columns so it can't be just as simple as adding an additional column with an 'if' statement before summing them. I need the single formula to perform both steps.
Thank you,
Chris
I'd like to sum the differences between two columns (B-A) but only for those rows where column B's value is greater than Column A's:
A | B | |
1 | 6 | 5 |
2 | 7 | 7 |
3 | 5 | 7 |
4 | 5 | 8 |
<tbody>
</tbody>
So my desired formula would produce '5' for this array, summing the difference for rows 3 and 4 because they are the ones that satisfy the criteria.
I can't make 'sumif' work for me b/c I don't know how to make it seek a neighboring column for its criteria. I have a spreadsheet with hundreds of columns so it can't be just as simple as adding an additional column with an 'if' statement before summing them. I need the single formula to perform both steps.
Thank you,
Chris