PC Review


Reply
Thread Tools Rate Thread

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!!!
 
Reply With Quote
 
 
 
Reply

Thread Tools
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


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:46 AM.