Adding sum of coloured cells
 

I have colomn B populated with times in the [h]:mm:ss format. These cells
are either coloured green or red depending on the data.

I am wantint to add all the reds together and all the greens together. is
this possible?

regards

Adding sum of coloured cells
 

If it is manually coloured, see
http://www.xldynamic.com/source/xld.ColourCounter.html, if it is
conditionally formatted, see
http://www.xldynamic.com/source/xld.CFConditions.html

--
__________________________________
HTH

Bob

"The Rook" wrote in message
...
I have colomn B populated with times in the [h]:mm:ss format. These cells
are either coloured green or red depending on the data.

I am wantint to add all the reds together and all the greens together. is
this possible?

regards