S
st_moose
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 tota
innings pitched by individual pitchers, data is kept about each game s
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 bu
all give ERRORS
any assistance would be GREAT!!!
thank
=DOLLARFR(SUMPRODUCT(INT(C2:C159)+DOLLARDE(MOD(C2:C159,1),3)),3)
have been trying without success to modify the formula to get tota
innings pitched by individual pitchers, data is kept about each game s
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 bu
all give ERRORS
any assistance would be GREAT!!!
thank