VLOOKUP & SUMIF

[Jock]

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'.

 

[Duke Carey]

That's what SUMIF() does

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

 

[Mike H]

Try this:-

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

Mike

 

[Jock]

Thanks gents.
--
tia

Jock

Try this:-

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

Mike

 

[Ari]

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

 

[Roger Govier]

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