Sumif from two criteria in one column
 

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

Sumif from two criteria in one column
 

=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

Sumif from two criteria in one column
 

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

Sumif from two criteria in one column
 

That worked thank you very much

"Peo Sjoblom" wrote:

=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

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