Sumif from two criteria in one column

[Guest]

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

 

[Peo Sjoblom]

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


adapt to fit your data

 

[Guest]

try:

=sumproduct((B2:B100)*(I2:I100={"OS","HO"}))

 

[Guest]

That worked thank you very much

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


adapt to fit your data

 

[Guest]

That works too, thank you very much

try:

=sumproduct((B2:B100)*(I2:I100={"OS","HO"}))