How to COUNT cell based on either COLOR or correct result?

[Kagesen]

Based on the attached Excel sheet: "How do I count the number of correct betting results i.e. "GREEN" cells for each player?

[FDibbins]

Based on your sample....
=SUMPRODUCT(--(D3:D11=E3:E11))

Note also, you do not need to use AND() in those CR rules. You use AND when you want to check the outcome of 2 or more tests...=AND(A1=1,B1=1,C1=1)

wit what you are doing, all you need is =E3=D3

[Kagesen]

Hi FDibbins,

Thank you for the swift reply. I just have an additional question. What's the purpose of writing "--" in your formula?

[FDibbins]

This part...
D3:D11=E3:E11

produces a series of TRUE or FALSE answers for the match/not match. the -- (double negative) converts the TRUE to 1...the 1st - creates a -1, the 2nd - converts that to positive.

Thanks for the feedback