Sum of a column based on color coded cells

  • Thread starter Thread starter MikeM
  • Start date Start date
M

MikeM

Looking for some help on what sounded like an easy thing
to do, but has me stumped. I have multiple columns of job
names that get color coded when complete or need to be
escalated etc.. A typical column may look like this.

JS-2133
JO-2011
MO-3320
NT-4510
and so on.

As the jobs are completed the cell is filled in green. I
would like a total at the bottom of the column, how do you
total only the green cells?

Thanks,
MikeM
 
Mike,

You could also check out this previous post

http://tinyurl.com/ydhj


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top