JWhite13Copper ContributorNov 30, 2023SolvedSubtract 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 ...Show MoreLorenzoNov 30, 2023Hi JWhite13 That could be:in I1:=SUMIF(C4:C28, "<>" & O10, K4:K28)IC-Multiple-Project-Tracking-10687.xlsx757 KB
LorenzoNov 30, 2023Hi JWhite13 That could be:in I1:=SUMIF(C4:C28, "<>" & O10, K4:K28)IC-Multiple-Project-Tracking-10687.xlsx757 KB
LorenzoNov 30, 2023Hi JWhite13 That could be:in I1:=SUMIF(C4:C28, "<>" & O10, K4:K28)IC-Multiple-Project-Tracking-10687.xlsx757 KB
LorenzoSilver ContributorNov 30, 2023Hi JWhite13 That could be:in I1:=SUMIF(C4:C28, "<>" & O10, K4:K28)IC-Multiple-Project-Tracking-10687.xlsx757 KB
