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.
 
Back
Top