SOLVED

Subtract if true

Copper Contributor

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.

 

Tracker 

3 Replies
best response confirmed by JWhite13 (Copper Contributor)
Solution

Hi @JWhite13 

 

That could be:

Sample.png

in I1:

=SUMIF(C4:C28, "<>" & O10, K4:K28)
That is exactly what I needed. Thank you!
You're welcome & Thanks for providing feedback
1 best response

Accepted Solutions
best response confirmed by JWhite13 (Copper Contributor)
Solution

Hi @JWhite13 

 

That could be:

Sample.png

in I1:

=SUMIF(C4:C28, "<>" & O10, K4:K28)

View solution in original post