SUMIF function with text color condition

[MrWallyWorld]

I am creating a simple addition formula but I want my formula to only count
numbers in corresponding row from text in the color blue(or red, green,
etc.). Help would be much appreciatted.

 

[Gord Dibben]

Visit Chip Pearson's site for working with colored cells.

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

See the SumByColor Function.


Gord Dibben MS Excel MVP

 

[Dave Peterson]

There's nothing built into excel that allows you to do this.

If you want a macro, you could use Chip Pearson's:
http://cpearson.com/excel/colors.htm

 

[Gord Dibben]

Both or at least one of us is redundant<g>


Gord

 

[Dave Peterson]

From the Department of Redundancy Department?

Both or at least one of us is redundant<g>

Gord