Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
still need help refreshing Web stats | Excel Discussion (Misc queries) | |||
Creating stats | Excel Discussion (Misc queries) | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Calculate and display individual error bars for individual points | Charts and Charting in Excel | |||
Football Stats: | Setting up and Configuration of Excel |