Formula for counting coloured cells.

[hotrod]

I have a table of numbers with conditional formating, formula's are...

=COUNTIF(OFFSET($W3:$AB3,1,0),W3+1)+COUNTIF(OFFSET($W3:$AB3,1,0),W3-1) - color, lemon.
=COUNTIF(OFFSET($W3:$AB3,-1,0),W3+1)+COUNTIF(OFFSET($W3:$AB3,-1,0),W3-1) - color, light blue.

Column AC, I want to count the number of cells that are lemon for each row.
Column AD, I want to count the number of cells that are light blue for each row.

Is it possible?

 

[Hooseria]

Hotrod

Not a problem at all, sorry for coming back to you so late.

In column F1 For the lemon Apply the following formula then paste down.
=SUMPRODUCT(COUNTIF(A2:E2,A3:E3-1))+SUMPRODUCT(COUNTIF(A2:E2,A3:E3+1))

In Column G6 the same, formula for blue is
=SUMPRODUCT(COUNTIF(A2:E2,A1:E1-1))+SUMPRODUCT(COUNTIF(A2:E2,A1:E1+1))

Please note, Row 1 must have a heading not the Numbers as per your example cause the blue checks Upwards, because there's no row above 1 you would get a ref# error.

Hope this helps, I've tested it on my side.

Cheers

 

[hotrod]

Yes, your formulas work.
Big thank you!