Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2003-Need seperate totals for - & + #'s in a cell range
The spreadsheet has one row for keeping track of personal hrs accurred, hr
used and hrs worked. The hrs used are indicated with a - (-2.0). I need a seperate total for the hrs used and hrs worked. Ex: Row 2,C2 thru E2 have the following entries: B2 = 20.75 (Beg Accural Bal) C2 = 2.0 (worked) D2 = -5.5 (used) E2 = 3.75 (worked) G2 - should equal hrs used H2 - Should equal hrs worked I2 - ending accural bal. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2003-Need seperate totals for - & + #'s in a cell range
Sydnee,
Try Sumif(C2:F2,"0",C2:F2) Of course "F" can represent any number of columns (e.g. ZZ) Cheers, APL "Sydnee" wrote in message ... The spreadsheet has one row for keeping track of personal hrs accurred, hr used and hrs worked. The hrs used are indicated with a - (-2.0). I need a seperate total for the hrs used and hrs worked. Ex: Row 2,C2 thru E2 have the following entries: B2 = 20.75 (Beg Accural Bal) C2 = 2.0 (worked) D2 = -5.5 (used) E2 = 3.75 (worked) G2 - should equal hrs used H2 - Should equal hrs worked I2 - ending accural bal. Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
EXCEL 2003-Need seperate totals for - & + #'s in a cell range
G2 =Abs(Sumif(C2:E2,"<0"))
H2 = Sumif(C2:E2,"0") I2 = Sum(B2:E2) -- Regards, Tom Ogilvy "Sydnee" wrote in message ... The spreadsheet has one row for keeping track of personal hrs accurred, hr used and hrs worked. The hrs used are indicated with a - (-2.0). I need a seperate total for the hrs used and hrs worked. Ex: Row 2,C2 thru E2 have the following entries: B2 = 20.75 (Beg Accural Bal) C2 = 2.0 (worked) D2 = -5.5 (used) E2 = 3.75 (worked) G2 - should equal hrs used H2 - Should equal hrs worked I2 - ending accural bal. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
add two cells from seperate work sheets into a cell on seperate wo | Excel Worksheet Functions | |||
Select the first cell of the last row in a range - Excel 2003 | New Users to Excel | |||
Stacked bar chart with totals - Excel 2003 | Charts and Charting in Excel | |||
Totals from Seperate Worksheets to One Consolidated Sheet | Excel Discussion (Misc queries) | |||
Adding Totals on Seperate Page | Excel Discussion (Misc queries) |