Help with Cell formulas please

**danumdave** · 09-28-2011, 06:09 AM

Hello,

I wondered if anybody could help please?

I use Excel 2003 and run a football predictions competition amongst friends each year

I wondered whether I could adapt my excel table to work out my rather complex points scoring system

I feel fairly confident that if I got started I would be OK

Basically if you correctly predict the outcome of a match, you score 10 points
years ago in BASIC that would have been something like
IF (a1=b1) THEN LET c1=c1+10

Where a = prediction b=Result and c= Points Tally for player

I looked at the help in MS and to be frank Im flumoxxed

I forgot to add the scores are entered as 2-1 where 2-1 the cell is formatted as Text

Thanks in advance

**Bob Phillips** · 09-28-2011, 06:24 AM

Try something like this in the results cell

=SUMPRODUCT(--(A1:A100=B1:B100),--(A1:A100<>""))*10

**danumdave** · 09-28-2011, 10:49 AM

Originally Posted by Bob Phillips

Try something like this in the results cell

=SUMPRODUCT(--(A1:A100=B1:B100),--(A1:A100<>""))*10

Thanks for your speedy reponse however, being on the nothing to limited end of
the Excel scale, could you possibly explain a little how A1:A100 etc formulas work
then I could alter the values accordingly

Many Thanks

Mr Dim