Countif Contains including a cell reference

Hi all

I had some awesome help the other day to help me figure out some stuff with my sales report. Unfortunately I need some more help.

I have a sheet that calculates what items are on any given transaction - this works well. I now want another table that counts how many times a certain brand comes up.

For example one item on a transaction might be "TENSOR REG TRUCK BLK 5.0 x2"

I need the table to look at this and count if tensor is in it (sheet name: 'Sheet 1') but I want it to look at the list of brands and and reference that brand rather than type it out individually.

I hope this sort of makes sense. Sample would be clearer.

Sample attached.

Many thanks.
For-Excel-Forum2.xlsm

Hi Ace, that's ace (pardon the pun)

Many thanks.
Ben

Also, thanks daffodil11.

Ben