sum of lookup

[Jonsson]

Hi,

I have this formula:

=(LETAUPP(C$5:C$206;'v1'!O$3:O$150;'v1'!S$3:S$150))

How to get a summary from several of the same lookup- value from sheet "v1"?

I have tried to write "Summa" before "(letaupp", but that does´nt work.
What shall I do to get it right?

Regards,

//Thomas

 

[Richard Choate]

What is the english version of your question please? What is LETAUPP?
--

Richard Choate, CPA

Hi,

I have this formula:

=(LETAUPP(C$5:C$206;'v1'!O$3:O$150;'v1'!S$3:S$150))

How to get a summary from several of the same lookup- value from sheet "v1"?

I have tried to write "Summa" before "(letaupp", but that does´nt work.
What shall I do to get it right?

Regards,

//Thomas

 

[Jonsson]

Hi Richard
Sorry, I forgot the english is different.
This is the english version

=(LOOKUP(C$5:C$206;'v1'!O$3:O$150;'v1'!S$3:S$150))

How to get a summary from several of the same lookup- value from sheet

"v1"?

I have tried to write "SUM" before "(LOOKUP", but that does´nt work.

What shall I do to get it right?
Regards,

//Thomas

 

[Alan Beban]

We're getting all tangled up in our underwear here. First, Richard
Choate is correct that the example doesn't seem to make much sense; the
OP should explain in words what he's trying to accomplish.

Second, Richard Choate's syntax is also incomplete; it doesn't include
the column(s) from which the return(s) are to be returned.

Third, you can indeed sum the multiple returns from a VLOOKUP formula,
whether those returns are from multiple lookup values or multiple return
columns.

=SUM(VLOOKUP(D8,A110,{2,3,4},FALSE)) array entered will return the sum
of the values from the 2nd, 3rd and 4th columns to the right of the
occurrence of the value from D8 in the left hand column of A110.

=SUM(VLOOKUP(D810,A1:C10,2,FALSE)) array entered into (oddly enough)
at least a two column row will return (to all selected cells) the sum of
the values from the second column of A1:C10 that correspond to the
multiple values from D810 that occur in the lefthand column of A1:C10.
If array entered into only 1 cell, this formula will return only the
value corresponding to the lookup value in D8, not the sum corresponding
to the lookup values in D810.

Alan Beban

 

[Alan Beban]

And fourth, this thread should be in . . .worksheet.functions, not in
. . .programming.

Alan Beban

 

[Jonsson]

Okey, Alan

Sorry for being in the wrong newsgroup. But as I´m already here I hope we
can finish this question in this group.
However, what I´m trying to do is this:
I have rows for several different persons in a sheet called "v1", and one
row for each customer in a sheet called"Jan".
Everytime I write for instance "1000" in "v1", I want excel to return a
value in "Jan" thats connected to "1000".
My formula can do that, no problem.
But, when "1000" appears in the same column in "v1" several times I dont
know how to get the values
summed.

I´m also sorry for my poor english, but I hope you can understand what I´m
trying to accomplish.

//Thomas

 

[Alan Beban]

Aha! We're almost there. Post (in this thread) the formula that works
for you for the, for example, Jan result for a single occurrence of, for
example, 1000.

Alan Beban