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

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

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