Sum by Fill colour
 

Is there a method that I can sum all cells of a certain cell colour? Eg. sum
of all cells colured red? TIA

Take a look at

http://cpearson.com/excel/colors.htm


In article ,
"Steve Wood" wrote:

Is there a method that I can sum all cells of a certain cell colour? Eg. sum
of all cells colured red? TIA

There is an example of using SUMPRODUCT and UDFs to count coloured cells at
http://www.xldynamic.com/source/xld.ColourCounter.html

The biggest problem is that changing a colour does not generate a worksheet
recalculation. One way around this is to use a button to set the colour, and
in the code associated with the button, do a sheet calculate
(Activesheet.Calculate). You would also need to add Application.Volatile to
the UDF.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Steve Wood" wrote in message
...
Is there a method that I can sum all cells of a certain cell colour? Eg.
sum
of all cells colured red? TIA

Hi
only possible with VBA. See
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm


--
Regards
Frank Kabel
Frankfurt, Germany
"Steve Wood" schrieb im Newsbeitrag
...
Is there a method that I can sum all cells of a certain cell colour? Eg.
sum
of all cells colured red? TIA