I want to sumif on a range of cells and only sum the shaded cells.
P Paul B Nov 21, 2003 #2 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 **
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 **
