Using cell color index like criteria in SUMIF

A

Ark

I need to count names in a table depending on a cell color index
criteria.
For example, I have a table in a range A1:C30 with names of workers.
In a range D1:F5 I have another table with unique list of those
worker's names in column "D".In column "E" I want to count names from
cells A1:C30 with green backcolor and in column "F" -from cells with
yellow backcolor for every worker.
Please help.
Thanks
 
B

Bob Phillips

Ark,

I have posted a solution to this many times which you can find at
http://tinyurl.com/ydhj

--

HTH

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