CountIfs with multiple conditions

[foxtrapperscott]

I am trying to count the number of a particular model number that is at a specific location. The data that I am pulling from has some models that start with the model number, but some have an extension on the end. For example "E50" or "E50 T4". I am wanting to count all units at that the specified location that starts with "E50" including the ones with the extension "T4" if at that location. The following is a sample:

Data
model location
E50 01 01 02 03 04 05 06
E50 03 WECO BONV BOF BOT BOR VEC
E50 T4 03 Model Group
E50 T4 03 E50 (Results) 1 0 4 0 4 3
E50 T4 03
E50 T4 05
E50 T4 05
E50 T4 05
E50 T4 05
E50 T4 06
E50 T4 06
E50 T4 06


Thank you for your help!

 

[foxtrapperscott]

I tried to spread the info out so I could demonstrate what it looked like, but when I submitted it all changed.

 

[Aladin Akyurek]

You can try one of the possible methods for posting useable samples listed in Attachments.

 

[Wicker]

Tell me if these work for you:
For just checking for starting with E50 = COUNTIFS(A3:A14,"E50*",B3:B14,1) where A=Model column and B=Location column
For checking starts with E50 and has T4 = COUNTIFS(A3:A14,"E50 T4",B3:B14,1) where A=Model column and B=Location column

Please not the "1" at the end of each formula is for the location; so for example if you wanted to count for location 5, you would simply change that 1 to a 5.