Highlighted color cells

[Limpan]

Hey,

I need to get help counting the amount in the result cell by the colour, a formula that can read the colour in the cells and percentage in the collumn to see the rate of all the different colours. anyone who know how?

So how many
Ja=Green
Nej=Red
Svarade inte=Yellow


Please need help

 

[vletm]

Limpan
If You've used Conditional Formatting to get those colors ...
... then You can find Your solution based those formulas.
Otherwise,
it's a challenge to guess solution without a sample Excel-file.

 

[pecoflyer]

You seem to have colored the rows manually based on the small Färgskala ( color scale?) table. Why not add a column with "ja","nej" and "svarade inte" instead of coloring.
Starting from there a quick Pivot Table or COUNTIF function will give you the answer within seconds
(you can also color the rows easily using Conditional Formatting (villkorlig formatering ?)