Thanks Roger; it worked like magic.

Ari

"Roger Govier" wrote:

Hi Ari

Supposing column A held a,b,c etc. and column B held Mercedes, Ford, GM etc
Also, column F held a mixture of those company names, and column G held
values associated with each entry

Now, enter b in cell C1 and use the formula
=SUMIF(F:F,VLOOKUP(C1,A:B,2,0),G:G)
and it will return the Sum of the values relating to Ford
--
Regards
Roger Govier

"Ari" wrote in message
...
But how do you include sumif in a vlookup such that the sum of multiple
instances is returned; for example if Ford appears three time with $1, $2,
&
$9, $12 is returned for the name Ford, because otherwise a regular vlookup
will return the value of the first instance found.

Thanks,

Ari

"Duke Carey" wrote:

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