=SUM(SUMIF(I2:I6,{"OS";"HO"},B2:B6))


adapt to fit your data


--
Regards,

Peo Sjoblom


"Terri" wrote in message
...
I am trying to sum column if column I meets two criteriam I have tried
sumif
and sumproduct with no results.


Columns A is Staff Names
Columns B thru G are week days
Column H adds total hours for individuals row
Column I designates if row hours are on site, home office, or over time

I want to sum the total for Monday if column I equals OS or HO

TABLE
NAME MON TUE WED THU FRI SAT SUN TTL TYPE
SMITH 8 8 8 8 8
40 OS
SMITH 2
2 OT
JONES 8 8 8 8 8
40 HO
JONES 1 1
2 OT

RESULTS
ST 16 16 16 16 16
OT 1 2 1

Thanks for any help

Terri