ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Count exact matches (https://www.excelbanter.com/excel-worksheet-functions/265363-count-exact-matches.html)

furyf

Count exact matches
 
Hi! A bit frustrated, been trying everything but can't get it to work properly.

I have a World Cup prediction pool at work, and have in columns everyone's prediction, and in the 1st column I have the correct result column. I need the formula to automatically update the scores after each result I input into the result column.

So far I have managed to get 48 using the DCOUNTA formula, but it always gives me 48, out 48 matches.

Example
Result Me Him
X 1 X
1 1 2
2 X 2
Points 1 2

Because I guessed the right answer for the right row only once, while him guessed 2 correct answers in 2 corresponding rows.

Please help me!!!!!


All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com