Hi, hopefully somebody can help….<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
I am putting together an office sweepstake for the Euro 2012 football with a score predictor. What I am trying to achieve is if a person guesses the actual goals scored of one team then they get one point, if they guess the actual goals scored correctly of both teams then they get two points. Anyone got any ideas on a formula that will automatically count up points when scores are entered? To explain further:<o></o>
<o> </o>
A cell that has the formula (if cell ref is the same as the prediction then add 1 but if both cells have the same prediction then add 2)<o></o>
fficeffice" /><o></o><o
> </o>I am putting together an office sweepstake for the Euro 2012 football with a score predictor. What I am trying to achieve is if a person guesses the actual goals scored of one team then they get one point, if they guess the actual goals scored correctly of both teams then they get two points. Anyone got any ideas on a formula that will automatically count up points when scores are entered? To explain further:<o
></o><o
> </o>A cell that has the formula (if cell ref is the same as the prediction then add 1 but if both cells have the same prediction then add 2)<o
></o>
