S
Simbo
Hello all
need help with something
I run a nascar pool for freinds and co-works and instead of hand
writing like i have been i would like to have excel due the math for
me.
Here is what i got so far
Sheet 1
Place that drivers came that week
A...........B.........C.........D.........E..........ECT
Place.. Points.. Week1 ... week2 ..... week3
1st ..... 20 ........ 8 ........... 21
2nd ..... 19 ...... 18 .......... 29
3rd ..... 18 ........ 9 ........... 8
Sheet 2
A..............B..............C..............D..............E
Player .. Picks ... Points
Week1 ... 2 ..........
=SUMIF(Sheet1!C2:B4,B2,Sheet1!B2:B4) =0
.............. 8 .........
=SUMIF(Sheet1!C2:B4,B3,Sheet1!B2:B4) =20
.............. 21 ........
=SUMIF(Sheet1!C2:B4,B4,Sheet1!B2:B4) =0
This Formula works fine but i need to do for 15 to 20 players, i wanted
to have all players on one sheet but when i try to copy the formula to
other cells it changes some of the cell references.
I really don't want to edit every cell there will be 6 picks per week
for 37 weeks at 20 players thats over 4000 cells ,
Any help would be great
need help with something
I run a nascar pool for freinds and co-works and instead of hand
writing like i have been i would like to have excel due the math for
me.
Here is what i got so far
Sheet 1
Place that drivers came that week
A...........B.........C.........D.........E..........ECT
Place.. Points.. Week1 ... week2 ..... week3
1st ..... 20 ........ 8 ........... 21
2nd ..... 19 ...... 18 .......... 29
3rd ..... 18 ........ 9 ........... 8
Sheet 2
A..............B..............C..............D..............E
Player .. Picks ... Points
Week1 ... 2 ..........
=SUMIF(Sheet1!C2:B4,B2,Sheet1!B2:B4) =0
.............. 8 .........
=SUMIF(Sheet1!C2:B4,B3,Sheet1!B2:B4) =20
.............. 21 ........
=SUMIF(Sheet1!C2:B4,B4,Sheet1!B2:B4) =0
This Formula works fine but i need to do for 15 to 20 players, i wanted
to have all players on one sheet but when i try to copy the formula to
other cells it changes some of the cell references.
I really don't want to edit every cell there will be 6 picks per week
for 37 weeks at 20 players thats over 4000 cells ,
Any help would be great