help with formula

Bob

Guest

Posts: n/a

9th Jul 2011

=IF(A30="","",SUM(C3:C25)*ROUNDUP(Worksheet2!G3/G1,0))
I only need to Sum (C3:C25) ONCE, Then after that, Sum (C3:C10) for
the remaining.
Example: If G3 lets say is 100 and G1 is lets say 25 then Sum C3:C25
only ONCE then Sum C3:C10 for the remaining count which is 75 in this
example.
C3:C25 is formatted as time, so is G4 where this formula is.
With this formula NOW it shows a total of 8 hours.
The way I need this formulas end result is to be 2.5 hours.
Thanks in Advance!!!

« Macro to select all the filled cells in a worksheet? | Parsing Data »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Replace formula with IF(error(formula;"";formula)	=?Utf-8?B?bGVjYWJhbGxlcm8=?=	Microsoft Excel Programming	1	2nd Nov 2005 12:46 PM
HELP NEEDED FAST!!! HELP HELP HELP HELP HELP HELP FAST HELP NEEDED	Jonathan	Windows XP General	10	13th Jan 2005 03:22 AM
HELP HELP HELP HELP HELP HELP	=?Utf-8?B?U2FuYXRhcml1bV83?=	Windows XP General	2	25th Sep 2004 04:00 PM
Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help! Help!	-$-	Windows XP Internet Explorer	2	21st Dec 2003 11:45 PM
Commenting custom formula fields/formula on formula editor	Muxer	Microsoft Excel Programming	2	24th Jul 2003 01:02 AM