Sum cells if certain color

[Montoro22]

Hi i need a function or macro so that I can sum or average cells if they are a certain color. I have no idea how to do this so any help is appreciated!

Thank you!

Rob

[zbor]

Does this help?

This sum by color and minimum value (if you don't need it you can remove it from the code or just put some very small number as -9.99999E-307

[Montoro22]

Sorry that didn't work. I think I need a macro of some sort

[zbor]

How do you mean it doesn't work?

Please Login or Register  to view this content.

ANd use just function: =SumByColor(A1, E2:J10)
where A1 is defined cell with your desired color
and rest is range