Hi Dave,

There are many tutorials on-line to show one how to do this, but I would ask first, how do the cells get colored in the first place?

If by some criteria, why not use that criteria to obtain a sum.

Anyway, see if this helps...