sumif function by colors

[Guest]

Is there a way that I can sum up cells in column A by colors? For example,
suppose I have a list of numbers in cells A1:A15. Cells A1, A3, A5, and A10
are colored light yellow. I would like to see a number in cell B1 that sums
up all cells in A1:A15 that are colored light yellow.

 

[Gord Dibben]

How did the cells attain their color?

If by Conditional Formatting simply sumif on that condition.

If colored manually, you will need VBA User Defined Function to sumif by color.

See Chip Pearson's site for info and code.

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


Gord Dibben MS Excel MVP

 

[Guest]

What is the formula if it were a conditional format?

 

[Bob Phillips]

See http://xldynamic.com/source/xld.CFConditions.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)