Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
still need help refreshing Web stats Walter Excel Discussion (Misc queries) 1 February 27th 08 12:09 AM
Creating stats mercedes Excel Discussion (Misc queries) 3 December 8th 06 05:28 PM
Calculate and display individual error bars for individual points del Charts and Charting in Excel 2 March 31st 06 05:11 PM
Calculate and display individual error bars for individual points del Charts and Charting in Excel 1 March 31st 06 04:24 AM
Football Stats: PanamaAz Setting up and Configuration of Excel 0 September 1st 05 07:07 PM


All times are GMT +1. The time now is 12:23 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"