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.

On Oct 6, 2:14*pm, Opal wrote:
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.

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

On Oct 6, 3:19*pm, wrote:
On Oct 6, 2:14*pm, Opal wrote:

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.

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

Thank you!