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