I have cells in a column, some colored yellow, some not. I am trying to use

the SUMIF function to sum only the cells in the range that are colored. Can

this be done? Can I enter something in the "criteria" part of the formula

that can do this?

=SUMIF(D3:D13,"criteria",D3:D13)

I also tried to use the CELL function's color feature, but I couldn't get it

to work right. I don't know how to get Excel to recognize if a cell is

colored in a formula.

=CELL("color",cell)

It might just be that I don't know what this means in Help:

"color" --> 1 if the cell is formatted in color for negative values;

otherwise returns 0 (zero).

Can anyone help?

## Bookmarks