Sum a range of Data that's not shaded gray

[Pete C.]

Hi,

I trying to figure out how to SUMIF only if the data in a cell is not shaded
gray.

On my spreadsheet, once an item in a column is shaded gray, it is complete.
If it is shaded any other color it is an accounts receivable. So I'm trying
to figure a quick way to add up my accounts receivables.

Any ideas would help...Thanks..Pete

 

[shah shailesh]

See below page from Chip's site,

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



Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)
If You Can't Excel with Talent, Triumph with Effort.