sum of lookup

  • Thread starter Thread starter Jonsson
  • Start date Start date
J

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
 
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
 
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
Click to expand...
"v1"?

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

//Thomas
Click to expand...
 
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,A1:D10,{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 A1:D10.

=SUM(VLOOKUP(D8:D10,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 D8:D10 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 D8:D10.

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

Alan Beban
 
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
 
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
 
Back
Top