=SUM based on color

[willie6112]

I have a column of numbers, including blank cells and cells with different font colors. Is it possible to add only those cells which are a specified font color, e.g., add only the cells with red font color? I'm using Excel 2011 for Mac.

 

[oldbrewer]

you presumably color them according to rules, so use those rules in a sumif or sumproduct approach

 

[willie6112]

I'm not familiar with "rules". Can you direct me to a discussion that tells me how to set up rules? Thanks

 

[Scott Huish]

What they mean is that you must be coloring the cells for some reason, base a formula on that reason.

 

[oldbrewer]

if cell is less than 10 make it red, if 10 to 19 make it yellow, 20 or above make it green

that is a conditional formatting rule ( or 3 rules to be pedantic)

 

[willie6112]

Thanks oldbrewer and Scott Huish. I'm going to practice with conditional formatting.