Forum Discussion
Solved
Subtract if true
I am trying to keep a running total of YTD revenue on a project tracker but remove any amounts from the sum if a specific label is applied in a different column. For example, if a job is not awarded and marked "Lost" in column C, I would like for the amount associated with that job to be removed from the total revenue. The worksheet is linked below.
