How to count innings pitched?

tomcat82

Junior Member

Posts: 5

Quote:

Originally Posted by Spencer101

Does =ROUNDUP(SUM(B1:B2),0) in A1 (with 6.1 in B1 and 5.2 in B2) do the trick?

No, because if the pitcher pitches another 4.2 innings in Game 3, he should have 16.2 innings pitched and not 17.

Game 1: 6.1
Game 2: 5.2
Game 3: 4.2
Game 4: 5.2

Should amount to 22.1 innings pitched

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
count duplicats, display incremental count, restart count at changein value	JenIT	Excel Programming	2	August 24th 10 09:10 PM
Converting Baseball Innings when Summed	Smooth813	Excel Discussion (Misc queries)	1	April 25th 10 12:10 AM
Count Employee Work Time - Don't Double-count Overlapping Apts.	J	Excel Worksheet Functions	0	April 27th 07 05:52 AM
formatting for innings pitched	Lara Shook	Excel Discussion (Misc queries)	8	October 19th 06 03:20 PM
Count Intervals of Filtered TEXT values in Column and Return Count across a Row	Sam via OfficeKB.com	Excel Worksheet Functions	9	July 31st 05 03:37 AM

All times are GMT +1. The time now is 08:15 AM.

Menu

About Us