Function 19)
Add Function SUMCOLORS to active workbook
=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