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
|