I figured it out. I used the CF in the sumif formula...

Thanks!

"Glenn" wrote:

Golfer Guy wrote:
Thank you for your speedy responce.
The values are in a specific Column (FG) and the cells have been conditional
formated. (to produce the background color)
As far as the sum, it can be placed at the bottom of the column.


If the background color is determined by conditional formatting, it may be
possible to use the same conditions to obtain your sum without VB. If you
provide some specifics about your worksheet, someone may be able to provide a
solution.