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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

putting info from one file into another using vba 3
Excel VBA - counting cells by colors and names to it in two different rows. 0
Help using Chip Pearsons code to count cells with color 9
Count by fiil color 9
Refresh - Value not refresh (URGENT) 3
Conditional Formatting - Applying Format Based Custom Functions 2
A way to refresh a certain cell everytime wroksheet changes 1
Counting Colors on a worksheet 1

Back
Top