On Feb 19, 4:31*pm, LiAD wrote:
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

Hi LiAD,
you find Excel Functions/Formulas to Count/Sum Excel Cells by Color on
oxgrid's site:
http://www.ozgrid.com/VBA/Sum.htm

HTH, have a nice day
Cheers Michael