Sum + countcolor

  • Thread starter Thread starter Opal
  • Start date Start date
O

Opal

Is it possible to use the sum formula and Chip Pearson's
countcolor function together? I have a range I want to
add based on 2 criteria. The first criteria is if there
is a value in the cell and the second is if the cell
is a specific colour.
 
Is it possible to use the sum formula and Chip Pearson's
countcolor function together?  I have a range I want to
add based on 2 criteria.  The first criteria is if there
is a value in the cell and the second is if the cell
is a specific colour.
Click to expand...

Hello Opal:

Chip has a function called SumColor that sounds like it will do just
what you are looking for. Check it out here.

http://www.cpearson.com/excel/colors.aspx

Steven
 
Back
Top