View Single Post
  #1   Report Post  
st_moose st_moose is offline
Junior Member
 
Posts: 1
Default 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