sum of values by font colour

I have values places in cells whereby the font colour is determined by conditional formatting. Is there a formular which allows me to sum the cells according to  font colours

By: Chris

3 thoughts on “sum of values by font colour

  1. Mike Massen

    Looking to SUM all cells in a column only if they are NOT some font colour Eg red and have that sum show in the first or second row as a summary etc.

    ie. How do I specify a range which doesnt include the first two rows but otherwise adds ALL the rows provided the font colour is NOT red etc ?

    Thanks 🙂

Leave a Reply

Your email address will not be published. Required fields are marked *