Hi Jock,

You can definitely combine VLOOKUP and SUMIF functions to achieve the desired result. Here's how you can do it:

1. First, you need to create a unique list of all the car brands that appear in column B. You can do this by selecting the entire column B, going to the Data tab, and clicking on the "Remove Duplicates" button.
   
2. Next, you need to create a formula that will return the sum of values in column C for each car brand. Here's the formula you can use:
   
   Code:

   =SUMIF(B:B, "Ford", C:C)

   In this formula, "Ford" is the car brand you want to sum the values for. You can replace it with any other car brand you want to calculate the sum for.
   
3. To make this formula work for all the car brands in your unique list, you can use the VLOOKUP function. Here's the formula you can use:
   
   Code:

   =VLOOKUP(E2, B:C, 2, FALSE)

   In this formula, E2 is the cell where you have the first car brand in your unique list. B:C is the range where you have the car brands and their corresponding values. 2 is the column number where you have the values you want to sum (in this case, column C). FALSE ensures that the exact match is found.
   
4. Copy this formula down to all the cells in the column where you have your unique list of car brands.
   
5. You should now have a list of all the car brands and their corresponding sums in the adjacent column.