SUMIF with cells that contain a PORTION of text conditions

Hello, Excel Experts:

I need to sum up the total software count by first finding portions of software titles within a column of titles that do not follow conventional standardized titles.

In the example below: I need to have Excel search for all of the cells in column D that contain the text "acrobat" AND "pro" AND "8", then sum up the count # (in column E) of the appropriate cells found.

RON!!!

I am in awe of your Excel Mastery!!! I have tried variations of sumif for TWO days and only NOW, thanks to you, do I have the solution!

You are AWESOME!!!! THANKS AGAIN!!!!

Thanks again to Ron for the previous help! I have one additional question with regard to the same formula:

What would I add if I wanted to exclude certain text within the search?

Rod

That did it, Ron!!!

Thanks again!!! I am DEFINITELY glad that I found this forum!

Rod

I have a similar question to this one. I would like to know if I can do a sumif formula which will sum all lines which contain a text string which is in another cell.
For example, I have a list of different SKUs of particular brands. There are 5 brands in total. I would like to sum the sales of each particular brand by refering to the brand name which will sit in column A. I'm trying avoid having to type in the brand's name for each instance, and also make it easier should I need to add another brand's set of SKUs.

This is what I have now:
=SUMIF($A$6:$A$325,"Alpine*",O$6:O$325)

Would like to instead refer to a cell which has Alpine in it to make it faster and easier to make changes to the table.

Hope this makes sense...
Thanks in advance.

Originally Posted by dbrunner281

I have a similar question to this one. I would like to know if I can do a sumif formula which will sum all lines which contain a text string which is in another cell.
For example, I have a list of different SKUs of particular brands. There are 5 brands in total. I would like to sum the sales of each particular brand by refering to the brand name which will sit in column A. I'm trying avoid having to type in the brand's name for each instance, and also make it easier should I need to add another brand's set of SKUs.

This is what I have now:
=SUMIF($A$6:$A$325,"Alpine*",O$6:O$325)

Would like to instead refer to a cell which has Alpine in it to make it faster and easier to make changes to the table.

Hope this makes sense...
Thanks in advance.

Never mind! Just figured it out two seconds after I posted this. Here is the solution. Use:
=SUMIF($A$6:$A$325,A327&"*",O$6:O$325)
A327 is the the cell containing "Alpine"

Originally Posted by Ron Coderre

Try this:

Please Login or Register  to view this content.

Is that something you can work with?

Found this after searching for what I needed. Did NOT think to use wildcard * in the formula. thank you very much.

Hello, I am attempting something similar to the original post, but am not having any luck. I want to use a sumif looking for text in isolation.

For example:
Beats on a drum - YES
Beatson a drum - NO
On a drum she beats - YES

I want to count all the instances where "beats" occurs in isolation, NOT as part of another word. All my wildcard combinations have not yiedled the results I am looking for.

Thanks in advanced!!

Originally Posted by Ron Coderre

Try this:

Please Login or Register  to view this content.

Is that something you can work with?

Please help. You obviously know your stuff with Excel. I have a formula similar to the one above.

Please Login or Register  to view this content.

column A contains lastname, firstname
Column B contains batting averages

The goal is to sum only where the last names are Chavez, Feliz, Gonzalez or Ogando. My Code above works but I don't understand why I have to encase the sumif(..) in sum ie =sum(sumif()). this code does not work with just sumif. If anyone can shed some light on this it would be much appreciated.

Thanks
Michael

SUMIF(A:A,{"*Chavez*","Feliz*","Gonzalez*","Ogando*"},B:B) part just produce the sequence of Column B, for example

A B
Chavez 10
Feliz 20
Gonzalez 30
Ogando 40

SUMIF(A:A,{"*Chavez*","Feliz*","Gonzalez*","Ogando*"},B:B) ,just produce {10;20;30;40} , you must encase with SUM Function.

or you change the code with individual formula like this :

=SUMIF(A:A,"*Chavez*",B:B)+SUMIF(A:A,"Feliz*",B:B)+ and so on........ the result will be the same but not elegant I guess.

Azumi