+ Reply to Thread
Results 1 to 2 of 2

Calculating on multiple variables

  1. #1
    DubboPete
    Guest

    Calculating on multiple variables

    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


  2. #2
    Forum Contributor
    Join Date
    03-21-2006
    Posts
    205
    In D10 enter:
    =sumproduct(--(D2:D9>E2:E9))*3

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1