EXCEL 2003-Need seperate totals for - & + #'s in a cell range

[Guest]

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

 

[alondon]

Sydnee,

Try Sumif(C2:F2,">0",C2:F2)

Of course "F" can represent any number of columns (e.g. ZZ)

Cheers,

APL

 

[Tom Ogilvy]

G2 =Abs(Sumif(C2:E2,"<0"))
H2 = Sumif(C2:E2,">0")
I2 = Sum(B2:E2)