Spreadsheet: 49437d1248794574-help-with-how-to-get-formula-to-show-correct-amount-team-sheets
Sheet: Main Score Sheet

NUMBER | PLAYER | CLUB | VALUE
5 | L Fabianski | Arsenal | 2.5
2 | M Almunia | Arsenal | 5
13 | B Friedel | [NAME] | 4.5
47 | J Hart | Birmingham City | 1.5
16 | M Taylor | Birmingham City | 1.5
84 | P Robinson | [NAME] | 3
20 | J Jaaskelainen | [NAME] | 4
22 | B [NAME] | Burnley | 1
24 | P Cech | Chelsea | 5.5
31 | T Howard | Everton | 5
35 | M Schwarzer | Fulham | 3.5
39 | B Myhill | Hull City | 1.5
43 | J Reina | Liverpool | 5.5
65 | S Given | Manchester City | 4.5
54 | [NAME] Sar | [NAME] | 5.5
51 | B [NAME] | [NAME] | 3
72 | D James | Portsmouth | 3.5
76 | S Simonsen | Stoke City | 1.5
74 | T Sorensen | Stoke City | 1.5
80 | C Gordon | Sunderland | 2.5
79 | M Fulop | Sunderland | 2
82 | Gomes | [NAME] | 4
27 | C Cudicini | [NAME] | 3
92 | R Green | West Ham United | 4
96 | C Kirkland | Wigan Athletic | 3.5
99 | W Hennessey | [NAME] | 1
98 | M Hahnemann | [NAME] | 1.5
110 | K Toure | Arsenal | 5
106 | B [NAME] | Arsenal | 5.5
105 | T Vermaelen | Arsenal | 5
104 | [NAME] | Arsenal | 5
102 | G Clichy | Arsenal | 5.5
273 | L Young | [NAME] | 3.5
124 | N Shorey | [NAME] | 3
119 | Z Knight | [NAME] | 3
117 | C Davies | [NAME] | 4
116 | C Cuellar | [NAME] | 4
115 | W Bouma | [NAME] | 3
412 | M Taylor | Birmingham City | 1
410 | L Ridgewell | Birmingham City | 1
408 | F Queudrue | Birmingham City | 1.5
406 | D Murphy | Birmingham City | 1
404 | R Jaidi | Birmingham City | 1
401 | S Carr | Birmingham City | 1
136 | S Warnock | [NAME] | 3
134 | C Samba | [NAME] | 3.5
131 | L Jacobsen | [NAME] | 2.5
130 | R Nelsen | [NAME] | 3
129 | G Givet | [NAME] | 2.5
126 | B Emerton | [NAME] | 2.5
361 | P Robinson | [NAME] | 2
155 | G Steinsson | [NAME] | 2
153 | J [NAME] | [NAME] | 2
149 | A [NAME] | [NAME] | 1.5
141 | G Cahill | [NAME] | 3
426 | C Kalvenes | Burnley | 1
424 | C Carlisle | Burnley | 1
422 | S Caldwell | Burnley | 1
420 | G Alexander | Burnley | 1.5
174 | J Terry | Chelsea | 7
171 | B [NAME] | Chelsea | 3
170 | A Cole | Chelsea | 5.5
168 | R Carvalho | Chelsea | 4.5
164 | J Bosingwa | Chelsea | 5.5
162 | J [NAME] | Chelsea | 3
160 | [NAME] | Chelsea | 5
189 | J [NAME] | Everton | 4
185 | J Lescott | Everton | 5
183 | P Jagielka | Everton | 4
181 | T [NAME] | Everton | 3
179 | L Baines | Everton | 3.5
199 | J Pantsil | Fulham | 1.5
198 | P Konchesky | Fulham | 2
197 | S Kelly | Fulham | 2
196 | A Hughes | Fulham | 2.5
194 | B [NAME] | Fulham | 4
209 | M Turner | Hull City | 2
207 | S Ricketts | Hull City | 1
205 | A Dawson | Hull City | 1
202 | [NAME] | Hull City | 1
201 | B [NAME] | Hull City | 1
297 | G [NAME] | Liverpool | 5.5
228 | M Skrtel | Liverpool | 4.5
220 | J Carragher | Liverpool | 6.5
218 | F Aurelio | Liverpool | 4
216 | A Arbeloa | Liverpool | 4
214 | D Agger | Liverpool | 5
241 | M Richards | Manchester City | 4.5
239 | N Onuoha | Manchester City | 3
236 | [NAME] | Manchester City | 3.5
166 | W Bridge | Manchester City | 4
258 | N Vidic | [NAME] | 7.5
255 | Rafael | [NAME] | 3.5
254 | J [NAME] | [NAME] | 4
252 | G Neville | [NAME] | 3
250 | R Ferdinand | [NAME] | 7
248 | P Evra | [NAME] | 6
247 | J Evans | [NAME] | 4
246 | W Brown | [NAME] | 3.5
298 | Y Kaboul | Portsmouth | 2.5
295 | H Hreidarsson | Portsmouth | 3
293 | S [NAME] | Portsmouth | 4
291 | S Campbell | Portsmouth | 3
450 | A Faye | Stoke City | 1.5
325 | [NAME] | Stoke City | 2
314 | A Wilkinson | Stoke City | 1
312 | R Shawcross | Stoke City | 1.5
310 | A Griffin | Stoke City | 1
306 | L Cort | Stoke City | 1
368 | A Ferdinand | Sunderland | 3
327 | P McShane | Sunderland | 2
323 | D Collins | Sunderland | 1.5
321 | P Bardsley | Sunderland | 2.5
346 | J Woodgate | [NAME] | 4.5
344 | L King | [NAME] | 3
342 | A Hutton | [NAME] | 3.5
338 | M Dawson | [NAME] | 3.5
334 | G Bale | [NAME] | 3
331 | B Assou-Ekotto | [NAME] | 3
235 | [NAME] | [NAME] | 4
376 | M Upson | West Ham United | 3.5
374 | L Neill | West Ham United | 3
371 | H Ilunga | West Ham United | 2
370 | D Gabbidon | West Ham United | 1.5
366 | J [NAME] | West Ham United | 1.5
389 | P Scharner | Wigan Athletic | 2.5
387 | M Melchiot | Wigan Athletic | 2
386 | M Figueroa | Wigan Athletic | 2.5
383 | T Bramble | Wigan Athletic | 2
381 | E Boyce | Wigan Athletic | 2.5
441 | R Stearman | [NAME] | 1
440 | M Hill | [NAME] | 1
438 | K Foley | [NAME] | 1.5
436 | G Elokobi | [NAME] | 1
434 | J Craddock | [NAME] | 1
432 | N Collins | [NAME] | 1
430 | C [NAME] | [NAME] | 1
514 | T [NAME] | Arsenal | 5
513 | A Song | Arsenal | 3
512 | T Rosicky | Arsenal | 4.5
509 | S [NAME] | Arsenal | 5
508 | F Fabregas | Arsenal | 7
506 | E Eboue | Arsenal | 3
504 | V Diaby | Arsenal | 3
502 | Denilson | Arsenal | 3
501 | A Arshavin | Arsenal | 7
691 | J Milner | [NAME] | 4.5
676 | S Downing | [NAME] | 3.5
527 | A Young | [NAME] | 5.5
526 | S Sidwell | [NAME] | 3.5
525 | N Reo-Coker | [NAME] | 3
523 | S Petrov | [NAME] | 3.5
533 | L Carsley | Birmingham City | 1.5
530 | S Larsson | Birmingham City | 1.5
725 | E Diouf | [NAME] | 2.5
540 | [NAME] | [NAME] | 2
537 | S N'Zonzi | [NAME] | 2
536 | M Pedersen | [NAME] | 3
535 | K Andrews | [NAME] | 1.5
534 | D Dunn | [NAME] | 2
698 | [NAME] | [NAME] | 2.5
553 | M Taylor | [NAME] | 3.5
552 | R Gardner | [NAME] | 2
550 | F Muamba | [NAME] | 2
549 | G McCann | [NAME] | 2
557 | C McCann | Burnley | 1
556 | J Gudjonsson | Burnley | 1
555 | W Elliott | Burnley | 1.5
554 | C Eagles | Burnley | 1.5
570 | J Mikel | Chelsea | 3.5
568 | F Malouda | Chelsea | 4
564 | F Lampard | Chelsea | 8.5
563 | Y Zhirkov | Chelsea | 4
562 | M Essien | Chelsea | 5
561 | [NAME] | Chelsea | 5
560 | J Cole | Chelsea | 4.5
558 | M Ballack | Chelsea | 5.5
585 | S Pienaar | Everton | 3.5
583 | L Osman | Everton | 3
581 | P Neville | Everton | 2.5
580 | M Fellaini | Everton | 4
579 | T Cahill | Everton | 4.5
577 | M Arteta | Everton | 4.5
724 | D Etuhu | Fulham | 2
598 | D Murphy | Fulham | 3.5
596 | Z [NAME] | Fulham | 2.5
594 | C Dempsey | Fulham | 3.5
592 | S Davies | Fulham | 3.5
531 | H Bouazza | Fulham | 1
789 | K Kilbane | Hull City | 1.5
613 | D Marney | Hull City | 1
610 | Geovanni | Hull City | 2.5
609 | R Garcia | Hull City | 1.5
607 | N Barmby | Hull City | 1.5
605 | I Ashbee | Hull City | 1.5
590 | J Bullard | Hull City | 3
631 | A Riera | Liverpool | 3.5
628 | J Pennant | Liverpool | 3
626 | J Mascherano | Liverpool | 4.5
624 | L Leiva | Liverpool | 3
622 | S Gerrard | Liverpool | 8.5
620 | Y [NAME] | Liverpool | 4.5
618 | X [NAME] | Liverpool | 5.5
644 | M Petrov | Manchester City | 4
641 | S Ireland | Manchester City | 5.5
636 | V Kompany | Manchester City | 3
635 | Elano | Manchester City | 4
634 | P Zabaleta | Manchester City | 3
633 | N de Jong | Manchester City | 2
572 | S Wright-Phillips | Manchester City | 5
519 | G Barry | Manchester City | 5.5
795 | L Valencia | [NAME] | 5
665 | P Scholes | [NAME] | 3.5
661 | J Park | [NAME] | 4
659 | Nani | [NAME] | 3.5
657 | O Hargreaves | [NAME] | 3.5
655 | R [NAME] | [NAME] | 4
653 | D Fletcher | [NAME] | 3.5
651 | M Carrick | [NAME] | 5.5
649 | [NAME] | [NAME] | 3.5
794 | N Belhadj | Portsmouth | 2.5
779 | H Mullins | Portsmouth | 2
704 | N Kranjcar | Portsmouth | 4
702 | P Bouba Diop | Portsmouth | 2.5
699 | R Hughes | Portsmouth | 2.5
773 | M Etherington | Stoke City | 1.5
717 | G Whelan | Stoke City | 1.5
715 | L Lawrence | Stoke City | 2
714 | A Faye | Stoke City | 1.5
713 | R Delap | Stoke City | 2
751 | S Malbranque | Sunderland | 3
736 | D Whitehead | Sunderland | 2.5
735 | T Tainio | Sunderland | 2
732 | K Richardson | Sunderland | 3
730 | A Reid | Sunderland | 2.5
726 | G Leadbitter | Sunderland | 2.5
793 | W Palacios | [NAME] | 4
757 | [NAME] | [NAME] | 2
755 | J O'Hara | [NAME] | 1.5
753 | L Modric | [NAME] | 5
749 | A Lennon | [NAME] | 5
747 | J Jenas | [NAME] | 4
745 | T Huddlestone | [NAME] | 3
532 | D Bentley | [NAME] | 3.5
784 | J Stanislas | West Ham United | 1.5
783 | S Parker | West Ham United | 3.5
782 | J [NAME] | West Ham United | 1.5
781 | M Noble | West Ham United | 3
769 | L Boa Morte | West Ham United | 2
768 | [NAME] | West Ham United | 2.5
791 | J [NAME] | Wigan Athletic | 2.5
790 | O Kapo | Wigan Athletic | 2.5
788 | J [NAME] | Wigan Athletic | 3
787 | M Brown | Wigan Athletic | 1.5
674 | L Cattermole | Wigan Athletic | 2.5
799 | M Kightly | [NAME] | 2
798 | D Jones | [NAME] | 1
797 | M Jarvis | [NAME] | 1.5
796 | D Edwards | [NAME] | 1
810 | C Vela | Arsenal | 2.5
808 | [NAME] | Arsenal | 7
806 | Eduardo | Arsenal | 4
804 | N Bendtner | Arsenal | 3.5
983 | E Heskey | [NAME] | 3.5
817 | J Carew | [NAME] | 4.5
815 | G Agbonlahor | [NAME] | 5
825 | K Phillips | Birmingham City | 2.5
823 | G O'Connor | Birmingham City | 1.5
822 | J McFadden | Birmingham City | 2
820 | C [NAME] | Birmingham City | 1.5
828 | J [NAME] | [NAME] | 3
826 | B [NAME] | [NAME] | 3
837 | J Elmander | [NAME] | 2.5
835 | K Davies | [NAME] | 3.5
994 | S Fletcher | Burnley | 2
993 | S Thompson | Burnley | 1
992 | M Paterson | Burnley | 1.5
991 | R Blake | Burnley | 1.5
844 | S [NAME] | Chelsea | 4
842 | D Drogba | Chelsea | 7.5
840 | N Anelka | Chelsea | 7.5
898 | L Saha | Everton | 3.5
890 | Jo | Everton | 4
855 | Yakubu | Everton | 4.5
978 | [NAME] | Fulham | 2.5
864 | E Nevland | Fulham | 2
863 | D Kamara | Fulham | 2.5
853 | A [NAME] | Fulham | 4
867 | D Cousin | Hull City | 1
866 | C [NAME] | Hull City | 1.5
882 | F Torres | Liverpool | 9
880 | D Kuyt | Liverpool | 5.5
974 | C Bellamy | Manchester City | 4
900 | C [NAME] | Manchester City | 5
893 | Robinho | Manchester City | 6.5
830 | R Santa Cruz | Manchester City | 5.5
802 | E Adebayor | Manchester City | 7
954 | D Berbatov | [NAME] | 6.5
918 | M Owen | [NAME] | 3
896 | W Rooney | [NAME] | 8
931 | J Utaka | Portsmouth | 2.5
901 | D Nugent | Portsmouth | 1.5
878 | P Crouch | Portsmouth | 4.5
938 | M Sidibe | Stoke City | 1.5
937 | R Fuller | Stoke City | 2
935 | J Beattie | Stoke City | 3
984 | F Campbell | Sunderland | 2.5
943 | K Jones | Sunderland | 3.5
860 | D Healy | Sunderland | 1.5
958 | R Pavlyuchenko | [NAME] | 3.5
956 | R Keane | [NAME] | 5
952 | D Bent | [NAME] | 3
927 | J Defoe | [NAME] | 5
976 | C Cole | West Ham United | 3
972 | D Ashton | West Ham United | 3
986 | H Rodallega | Wigan Athletic | 1.5
985 | M King | Wigan Athletic | 1.5
803 | J Scotland | Wigan Athletic | 1.5
999 | K Doyle | [NAME] | 2
998 | S Ebanks-Blake | [NAME] | 2.5
997 | S Vokes | [NAME] | 1
996 | A Keogh | [NAME] | 1
995 | C Iwelumo | [NAME] | 1