Can I Sum by Cell Colour or Format?

[Ashley]

I have a large list of values, these values have been colour coded. I would
like to sum each of the colours seperately. I know i can add a filter, sort
by colour & sum this for each coulour, but am wondering if there is a formula
that would do this for me?

 

[Mike H]

Ashley,

have a look here

http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.