ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   summing individual pitcher stats (https://www.excelbanter.com/excel-worksheet-functions/445993-summing-individual-pitcher-stats.html)

st_moose

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


All times are GMT +1. The time now is 07:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com