That's what SUMIF() does

=SUMIF(B2:B20,"Ford",C2:C20)

"Jock" wrote:

I wish to somehow combine these two functions so that if "Ford" for instance
appears six times in column 'B' then the SUMIF part then returns the sum of
the values relating to "Ford" from column 'C'.
--
tia

Jock