Hi,

Is it possible to have sum if cell = a colour?

If for example from row A1 to 20 I have a list of numbers each with or
without a cell fill colour as required. Is there a formula, (not code), I
can use to calculate the sum of all the cells coloured in grey for example
(colour index 15)?

Thanks
LiAD