can I use the sumif function with cell formatting as the criteria

  • Thread starter Thread starter Dean
  • Start date Start date
D

Dean

I want to be able to add the values in a column of cells based on the color
formatting of that cell as the criteria. Is there a way to do that with
sumif or is there some other function that will do that?
 
Hi,

You can't use any of Excel's functions to sum based on color unless the
color is itself applied based on a condition which you can enter in a regular
formula. You can write a VBA function to sum based on color.
 

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

SUMIF with criteria "<>" & "=" 4
How do I use the SumIF function with a criteria of a cell color? 3
=sumif function 1
SUMIF Function ? 1
Sumif using Arrays 2
Specifying comparision criteria with SUMIF() 2
sumif wildcard criteria 1
Sumif problem with zero value and blank cells 6

Back
Top