Sumif from two criteria in one column
That works too, thank you very much
"Toppers" wrote:
try:
=sumproduct((B2:B100)*(I2:I100={"OS","HO"}))
"Terri" wrote:
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
|