Function 18)

18) Add Function SumColors

Using the function

=SumColors( SumRange , PatternCell)

You can SUM all the cells in your SumRange that match your PatternCell in both font color and fill color. I almost always place my formula in the PatternCell.

Queries | Lists | Find | Alter | Clean | Sum | Functions | Help | Misc