SUMIF by colour

[patje]

How can I get the sum of cells, with a given colour.

E.g.
When in the same column green, yellow and red cells are specified.
And evenry cell has a different value.
Wich formula can I use to get the sum of all green cells, all yellow cells and all red cells?

Thanks for your replies.

Greetings Patje

 

[VoG]

If manually coloured look here 2 Excel Functions/Formulas to Count/Sum Excel Cells by Color - Excel VBA User Defined Functions

 

[Scott Huish]

What is the criteria for the green, yellow, and red designations? If there is one, build a formula for those conditions.

If there is no set criteria, and the cells are manually colored, it will take VBA.

Please clarify.

 

[patje]

There is an overview available with cells in a column, containing different values.
At the bottom of this list a cell is available to give the sum of cells with a specific colour.

If I given the cells, to be summerized, a yellow colour the sum has to be the result of these yellow coloured cells. This by making the SUM cell a yellow colour.
If another range of cells are given a green colour, and I given the SUM cell a green colour, the result shout be the sum of all green cells.

 

[patje]

Hopefully this is clear enough.

 

[Scott Huish]

Yes, I understand, but what is the reasoning behind a cell having a different color? Why would a cell be green instead of yellow? How are they colored, manually or by conditional formatting?

 

[patje]

There is a list with different options for different groups. Every group has his own colour and can choose from the same list. By giving a cell manually the group colour, the total gives the result for the specific group.

 

[Scott Huish]

The VBA at the link VoG posted should do what you want.