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