Special Conditional Sum

[OscarAGC]

Column A Column B

Apple-Red 10
Apple-Green 10
Apple- Yellow 10
Orange-Navel 5
Orange-Tangelo 7
Grape-Purple 30
Grape-Green 30

I want to sum Column B if Colum A contains Apple. The answer here would be 30.

I've tried a combination of sum, vlookup, and search with wildcard "* *", but I can't get it.

PLEASE HELP!

 

[schielrn]

Welcome to the Board!

Try:

=sumif(A:A,"*Apple*",B:B)

But depending on your circumstances you may want:

=sumif(A:A,"*Apple-*",B:B)

Because the former would also count Grape-GreenApple as apple. Which I don't think you want.

Hope that helps.

 

[texasalynn]

Welcome to MrExcel Board...

try

=sumif(A1:a10,"Apple",B1:B10)

 

[OscarAGC]

Schielrn- YOU ARE THE MAN!-I'm also an accountant, so I'm glad you were vibin' on this one. MUCH APPRECIATED!