Based on the attached Excel sheet: "How do I count the number of correct betting results i.e. "GREEN" cells for each player?
Based on the attached Excel sheet: "How do I count the number of correct betting results i.e. "GREEN" cells for each player?
Last edited by Kagesen; 05-12-2014 at 12:32 AM.
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
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi FDibbins,
Thank you for the swift reply. I just have an additional question. What's the purpose of writing "--" in your formula?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks