Adding sum of coloured cells

  • Thread starter Thread starter The Rook
  • Start date Start date
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
 
Back
Top