VLOOKUP & SUMIF
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
|