I'm using a dutch excell version
I want to get a % by using the color of a cell. I have white, green en red cells.
I want the next formula
red cells/(red cells + green cells)
I found the next formula
=sumproduct(--(colorindex(range)=3)) that must count the red cells but as i translated it to
= somproduct(--(kleurindex(range)=3)) i get #Naam?
what is wrong?
Ger