Forum Discussion
use sumif function when criteria is cell hihlighted with a color highlight
I want to use sumif function to add a column of numbers when criteria is a fill color in the cells. How do I do this.
As I mentioned in another reply, updating is not automatic - changing a cell's color does not trigger an event in Excel. You'll have to press F9 to update the result.
Ok, thank you. I missed that post.