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


More Information

During the last 23 years we have created over 300 solutions for end users (we've stopped counting).