Hi,
I have the following spreadsheet set up in a similar manner:
Amount Commitment
55,000 Y
700,000 Y
2,000 N
----------------------
757,000
For the Commitment column, I would like to add a formula that will calculate the total amount from the previous column only if Commitment is set to "Y". Essentially the end result would be:
Amount Commitment
55,000 Y
700,000 Y
2,000 N
----------------------
757,000 755,000
What would be the formula that I would use? Thank you.
I have the following spreadsheet set up in a similar manner:
Amount Commitment
55,000 Y
700,000 Y
2,000 N
----------------------
757,000
For the Commitment column, I would like to add a formula that will calculate the total amount from the previous column only if Commitment is set to "Y". Essentially the end result would be:
Amount Commitment
55,000 Y
700,000 Y
2,000 N
----------------------
757,000 755,000
What would be the formula that I would use? Thank you.