Need Some Excel Help

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Stocks
    SBR Wise Guy
    • 11-01-10
    • 569

    #1
    Need Some Excel Help
    Hey guys I need some help in excel I have a problem that is driving me retarded and I'm actually at the point where I got to hold myself back from just smashing my computer.

    I'll attach my worksheet so it will help with what I'm talking about.

    Sheet 1 is what I'm working on

    Ok I'm trying to find column I which is SOS (strength of schedule)

    SOS is an average of the MOV (margin of victory) of the teams a team has played so to find Buffalo's SOS you find the average MOV of all the teams Buffalo has played.

    You can do that manually by using a formula like =AVERAGE(H2,H25,H5,H4,H24,H9,H7,H6,H13,H 22,)

    but I need it to it automaticaly when I add new games to the left part columns A to D and to do this you need to use the average if function something like this

    =AVERAGE(IF($B$2:$D$207=G2,$B$2:$D$207))

    Anyway I cant figure out the exact average if formula and its just driving me mental.
    Attached Files
  • djiddish98
    SBR Sharp
    • 11-13-09
    • 345

    #2
    Starting with F2 // =VLOOKUP(D2,G:H,2,FALSE)
    Starting with I2 // =AVERAGEIF(B:B,G2,F:F)

    My SOS isn't matching yours, so let me proof this and see if I can figure out what's up.
    Comment
    • aggieshawn
      SBR MVP
      • 01-24-07
      • 4377

      #3
      Buy an excel for dummies book.
      Comment
      • Stocks
        SBR Wise Guy
        • 11-01-10
        • 569

        #4
        Originally posted by djiddish98
        Starting with F2 // =VLOOKUP(D2,G:H,2,FALSE)
        Starting with I2 // =AVERAGEIF(B:B,G2,F:F)

        My SOS isn't matching yours, so let me proof this and see if I can figure out what's up.
        My SOS might be a bit diffderent because I have blowout wins capped at 21 points.
        Comment
        • djiddish98
          SBR Sharp
          • 11-13-09
          • 345

          #5
          Originally posted by Stocks
          My SOS might be a bit diffderent because I have blowout wins capped at 21 points.
          Your average formula for Miami had an extra comma in it, which I guess it registering as a 0. Should match now.
          Comment
          • Stocks
            SBR Wise Guy
            • 11-01-10
            • 569

            #6
            Cool man that worked thanks I appriciate it

            Thats kind of different than the example I was looking at

            World's leading screen capture + recorder from Snagit + Screencast by Techsmith. Capture, edit and share professional-quality content seamlessly.


            Its says your supposed to use the replace function to replace the oSRS and then thats creates sort of a loop the video explains it better.

            I tried it but it did'nt change our final SRS numbers
            Comment
            SBR Contests
            Collapse
            Top-Rated US Sportsbooks
            Collapse
            Working...