Using cell color index like criteria in SUMIF

  • Thread starter Thread starter Ark
  • Start date Start date
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
 
Hi Ark!

You need a custom function for this. See:

Chip Pearson:
http://www.cpearson.com/excel/colors.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
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)
 
Back
Top