Try this:-

=IF(COUNTIF(B1:B100,"=Ford")=6,SUMIF(B1:B100,"=For d",C1:C100),"not six fords
in this list")

Mike

"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