Forum Discussion
dickcarey460gmailcom
Feb 28, 2023Copper Contributor
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.
FikturFox
Feb 28, 2023Brass Contributor
If you have a criteria in colouring the cells, use it as a criteria in your SumIfs() fn, else you'll have to create a user defined function with VBA to achieve that.