On Sun, 20 Aug 2006 09:30:01 -0700, pvuv
wrote:

hello.
i am a project planner and doing a quantity analysis whose spreadsheet is
huge & simalar to this eg :

code quantity
a 12
s 3
d 45 total A = 12
a 6
g 67
a 7
d 88

when i tried the vlook up finction =VLOOKUP(A2,A1:B8,2,FALSE)
it gives me the value 12 instead of the summation (12+6+7= 25)

is dere any way i can get multiple values using vlokup.

Not with Vlookup but try

=SUMIF(A:A,"A",B:B)

Better still, since you may want totals for all the column A values,
take a unique list of all column A valuse in say Column C, then in D1
put

=SUMIF(A:A,C1,B:B)

and copy down.

HTH


__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________