VLOOKUP & SUMIF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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'.
 
Try this:-

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

Mike
 
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
 
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
 
Thanks Roger; it worked like magic.

Ari

Roger Govier said:
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
Click to expand...
 
Back
Top