Good morning. Here's my sheet:
Here's the formula I wrote in Column B:
I can't figure out how to ignore a No value in Column E so that only rows with a Yes value increment backwards. I entered the -3 to show what I'm looking to do with the formula.
Am I close?
Here's the formula I wrote in Column B:
Excel Formula:
=IF(COUNTIF($E142,"Yes"),$B143 - 1,$B143)
I can't figure out how to ignore a No value in Column E so that only rows with a Yes value increment backwards. I entered the -3 to show what I'm looking to do with the formula.
Am I close?