Sumif based on conditional format
Posted by Uttam on May 21, 2001 12:56 PM
Consider the following worksheet with the following values:
A1 = "Actual"
B1 = "Projected"
C1 = "Projected"
A2 = 10,000
B2 = 20,100
C2 = 30,200
Row 2 has conditional formatting - when the content of Row 1 in the same column has "Actual" the text is in Green. If it is "Projected" the text is in Red.
Column D is my Actual Totals Column and Column E is my Projected Totals Column.
Hence, in Cell D2 I would like to sum up cells (A2:C2) which have Green text.
And in Cell E2, the sum will be of Red Text.
Most important: if I change any of the A1, B1 or C1 from "Actual" to "Projected" and vice versa, I would like Totals in D2 and E2 to change appropriately.
Any help deeply appreciated.