Calculating on multiple variables

[DubboPete]

Hi all,

I'm trying to create a points table, to calculate for the upcoming
Soccer World Cup. Here's what I need help in doing:

cell d2 will contain a score. If that score is greater than e2, (the
opponents score) then cell d10 will be 3(pts). Then, if the same team
has another score in d4, which is greater than e4, then d10 will be d2
+ d4.

And so on through the group. So what I need is a formula to say:

if D2 > E2 THEN D10= 3 OTHERWISE IT'S 0 AND IF D4 > E4 THEN D10 = D10+3
OTHERWISE D10 = D10

Does this create some sort of circular reference problem? Can anyone
help?

much appreciated
TIA

DubboPete

 

[John James]

In D10 enter:
=sumproduct(--(D29>E2:E9))*3