Hi,

I'm having trouble using a sum formula based on the conditions. I've spent
the last few hours trying multiple formulas that have been suggested on here
but still can't get it!

In the below data I'm trying to sum Column C when Column A starts with 'E'
and Column 'B' contains "COMP OWN". The result i'm looking for is $5,258.60
A B C
CQBR COMP OWN 1,722.87
CVME COMP OWN 345.73
CVME COMP OWN 820
ENSY COMP OWN 2,010.64
ESAD COMP OWN 662.6
EVME COMP OWN 1,775.36
EVME COMP OWN 810
EVME PLANT OWN 2500.00

Any help would be greatly appreciated!

Thanks for reading.

=SUMPRODUCT(--(LEFT(A1:A8)="E"),--(B1:B8="COMP OWN"),C1:C8)

"Shaun" wrote:

Hi,

I'm having trouble using a sum formula based on the conditions. I've spent
the last few hours trying multiple formulas that have been suggested on here
but still can't get it!

In the below data I'm trying to sum Column C when Column A starts with 'E'
and Column 'B' contains "COMP OWN". The result i'm looking for is $5,258.60
A B C
CQBR COMP OWN 1,722.87
CVME COMP OWN 345.73
CVME COMP OWN 820
ENSY COMP OWN 2,010.64
ESAD COMP OWN 662.6
EVME COMP OWN 1,775.36
EVME COMP OWN 810
EVME PLANT OWN 2500.00

Any help would be greatly appreciated!

Thanks for reading.

Thanks so much for your help, it worked. I think I was having trouble with
the "E" part of the formula.

Thanks again.

"Teethless mama" wrote:

=SUMPRODUCT(--(LEFT(A1:A8)="E"),--(B1:B8="COMP OWN"),C1:C8)

"Shaun" wrote:

Hi,

I'm having trouble using a sum formula based on the conditions. I've spent
the last few hours trying multiple formulas that have been suggested on here
but still can't get it!

In the below data I'm trying to sum Column C when Column A starts with 'E'
and Column 'B' contains "COMP OWN". The result i'm looking for is $5,258.60
A B C
CQBR COMP OWN 1,722.87
CVME COMP OWN 345.73
CVME COMP OWN 820
ENSY COMP OWN 2,010.64
ESAD COMP OWN 662.6
EVME COMP OWN 1,775.36
EVME COMP OWN 810
EVME PLANT OWN 2500.00

Any help would be greatly appreciated!

Thanks for reading.

You're Welcome!

"Shaun" wrote:

Thanks so much for your help, it worked. I think I was having trouble with
the "E" part of the formula.

Thanks again.

"Teethless mama" wrote:

=SUMPRODUCT(--(LEFT(A1:A8)="E"),--(B1:B8="COMP OWN"),C1:C8)

"Shaun" wrote:

Hi,

I'm having trouble using a sum formula based on the conditions. I've spent
the last few hours trying multiple formulas that have been suggested on here
but still can't get it!

In the below data I'm trying to sum Column C when Column A starts with 'E'
and Column 'B' contains "COMP OWN". The result i'm looking for is $5,258.60
A B C
CQBR COMP OWN 1,722.87
CVME COMP OWN 345.73
CVME COMP OWN 820
ENSY COMP OWN 2,010.64
ESAD COMP OWN 662.6
EVME COMP OWN 1,775.36
EVME COMP OWN 810
EVME PLANT OWN 2500.00

Any help would be greatly appreciated!

Thanks for reading.