Function 19)


Add Function SUMCOLORS to active workbook

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