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

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
 

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

Auto Sum not working correctly 1
Subtotal for text fields 0
No difference between SUM and SUBTOTAL (9) 1
correlating and summing data from multiple spreadsheets 1
Wrong sum value after calculate with Percentage 12
conditionally formatting colour of cells 2
Sum cells in columns based on condition 5
sum cells based on contents of adjacent cell (validated list)? 3

Top