Gilles and Gord,
Thanks for the information. I figured that I would end up having
to use VBA but was hoping there might be a worksheet function that
could handle this.

I think I can modify the sumifbycolor to accomplish what I'm after and
just have a button the user can click to recalcuate the sheet after
they have changed any colors.

Thanks again


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=384693