Adding sum of coloured cells

T

The Rook

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sum coloured cells 1
Finding coloured cells 2
Excel 2003 :Summing specific cells of a particular color in a colu 2
adding values in coloured cells 2
SUM - IF - AND 7
Excel Bar Chart 3
Sum of coloured cells in execel 2007 2
percentage of green cells in list 3

Top