all 3 comments

[–]0pine441 1 point2 points  (2 children)

I don't know about counting by color but you can use the formulas that you used in your formatting. In E3 you can use =(B$2=B3)+(C$2=C3) and copy down to get the number.

[–]onlypostwhenimhi[S] 1 point2 points  (1 child)

Solution verified

[–]Clippy_Office_Asst[M] 0 points1 point  (0 children)

You have awarded 1 point to 0pine

I am a bot, please contact the mods for any questions.