Two column sum

[Mussman]

I have a complex problem with getting an inventory count from two columns. I want to get a count of each piece of equipment on a technicians truck. Here is a small portion of data

Area Equipment Dat
Steve 30SW21-00001 4180
Steve 30SW21-00002 4180
Steve 30DLNB-00001 4180
Steve 30DLNB-00002 4180
Steve 30DLNB-00003 4180
Steve 30DPQLNB-00001 4180
John 30SW21-00003 4180
John 30DLNB-00004 4180
John 30DLNB-00005 4180
John 30DPQLNB-00005 4180
John 30SLNB-00001 4180
John 30SLNB-00002 4180
John 30SLNB-00003 4180

For example, How would I get a count of 30DLNB on John or Steve's truck
We use unique lablels for each piece of equipment but the data before the hyphen decribes the equipment and always stays the same and the number after the hyphen will always be different. I have not had much success getting a wild card to work like 30DLNB-*. I need to do this with about 20 different pieces of equipment. The date only shows me when the equipment was scanned to the technician and does not play a role with the count. Any help would be appreciated.

 

[Aladin Akyurek]

Let A1:C14 house the sample you provided, including labels...

=SUMPRODUCT(--($A$2:$A$14=E2),--ISNUMBER(SEARCH(F2,$B$2:$B$14)))

where E2 houses a value like John and F2 a value like 30DLNB.

I have a complex problem with getting an inventory count from two columns.

I want to get a count of each piece of equipment on a technicians truck.
Here is a small portion of data:

Area Equipment Date
Steve 30SW21-00001 41804
Steve 30SW21-00002 41804
Steve 30DLNB-00001 41804
Steve 30DLNB-00002 41804
Steve 30DLNB-00003 41804
Steve 30DPQLNB-00001 41804
John 30SW21-00003 41804
John 30DLNB-00004 41804
John 30DLNB-00005 41804
John 30DPQLNB-00005 41804
John 30SLNB-00001 41804
John 30SLNB-00002 41804
John 30SLNB-00003 41804

For example, How would I get a count of 30DLNB on John or Steve's truck?
We use unique lablels for each piece of equipment but the data before the

hyphen decribes the equipment and always stays the same and the number after
the hyphen will always be different. I have not had much success getting a
wild card to work like 30DLNB-*. I need to do this with about 20 different
pieces of equipment. The date only shows me when the equipment was scanned
to the technician and does not play a role with the count. Any help would be
appreciated.

 

[Mussman]

Aladin,Thank you for the help. That worked