+ Reply to Thread
Results 1 to 2 of 2

Complicated Averaging in 3D

  1. #1
    Registered User
    Join Date
    11-04-2008
    Location
    Fort St. John, BC, Canada
    Posts
    1

    Complicated Averaging in 3D

    I am setting up a standings for a weekly darts leage where points are awarded base on how you finish. Each week is a new sheet. Each weekly sheet has the names in Column B but do not always apear in the same cell. Points are in Column C. Only the Top 7 sores count for your average. On my Totals sheet I can get the total points with

    =SUMPRODUCT(((THREED(Start:Blank!$B$2:$B$75))=$A2)+0,(THREED(Start:Blank!$C$2:$C$75)))

    and total # of times played with

    =COUNTIF.3D(Start:Blank'!$B$2:$B$40,A2)

    The Name in the Totals sheet is in Column A, so A2 is a Name of the person.

    I had a formula last year that used mmax() and average() I believe, and I had a computer malfunction and could not retrive the files. Could somebody please help me?

    Victor

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,885
    Dodgeboy, please read the forum rules (link at top of each forum, and in my signature) and provide a link to your cross-post at MrExcel.com.

+ 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