summing individual pitcher stats
I am using this formula to calculate total innings pitched by a team
=DOLLARFR(SUMPRODUCT(INT(C2:C159)+DOLLARDE(MOD(C2: C159,1),3)),3)
have been trying without success to modify the formula to get total innings pitched by individual pitchers, data is kept about each game so the pitcher will appear multiple times throughout the season
the players names are in column A, the innings pitched are in column C
have tried a SUMIF, VLOOKUP, and a few others that I don't remember but all give ERRORS :(
any assistance would be GREAT!!!
thanks
|