Is is possible to use cell shading within a formula?

[Guest]

I want to sumif on a range of cells and only sum the shaded cells.

 

[Paul B]

P, have a look here http://www.cpearson.com/excel/colors.htm

--
Paul B
Always backup your data before trying something new
Using Excel 2000 & 97
Please post any response to the newsgroups so others can benefit from it
** remove news from my email address to reply by email **