to obtain a sum of all the cells in colour in a column

  • Thread starter Thread starter sayvari
  • Start date Start date
S

sayvari

Hello,

I have worksheet with Subtotals having around 20000 Rows, after havin
rectified the necessary corrections I turn the relevant numbers i
GREEN. Is there a function to arrive at the sum of all the number
turned GREEN, so I can calulate a percentage of the amounts in GREE
against the GRAND TOTAL.

All suggestions welcome.

Sayvar
 
Back
Top