Hi,

You can't use any of Excel's functions to sum based on color unless the
color is itself applied based on a condition which you can enter in a regular
formula. You can write a VBA function to sum based on color.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Dean" wrote:

I want to be able to add the values in a column of cells based on the color
formatting of that cell as the criteria. Is there a way to do that with
sumif or is there some other function that will do that?