Chip's site has a lot of great stuff and I am not the one to explain
those functions; but, it seems to me that you could possibly avoid the
function you are trying to use by using the same conditional criteria
used to generate the color in the first place in a sumif formula to do
what you want.

Ken
Norfolk, Va