A friend has a worksheet that some cells are shaded, others aren't. The
shaded cells values are to be summed. Right now, he's writing a different
formula for each row of data to calculate the sum of the shaded cells. Is
there any way to test for a shaded cell and only put it's value into the
sum? Somehow to put that in say the first row of the sum column, and then
copy it down?


Thanks!
Shawn

--
Join the newest in Fantasy Sports.

http://www.6FantasySports.com
(this site supports the Victory Junction Gang Camp with a portion of all
proceeds)