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

"Jonsson" wrote in message
...
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
"v1"?

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

Regards,

//Thomas



"Richard Choate" skrev i meddelandet
...
What is the english version of your question please? What is LETAUPP?
--

Richard Choate, CPA

"Jonsson" wrote in message
...
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

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

Richard Choate wrote:
The lookup function will return one record as a result, based on your
criteria., Therefore there is nothing to add. If you have several lookups in
a column, you can run a sum on the group of lookups, but you can't sum a
single lookup. Your example does not seem to make sense. The first parameter
should be a single value or cell reference. The other 2 should basically
allow you to tell where you want to find it. Check the syntax in help.
Generally it is like: =(LOOKUP(C$206,'v1'!O$3:O$150)).
--
HTH
Richard Choate, CPA

"Jonsson" wrote in message
...
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




"Richard Choate" skrev i meddelandet
...

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

Richard Choate, CPA

"Jonsson" wrote in message
...
Hi,

I have this formula:

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

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

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

Alan Beban

Richard Choate wrote:
The lookup function will return one record as a result, based on your
criteria., Therefore there is nothing to add. If you have several lookups in
a column, you can run a sum on the group of lookups, but you can't sum a
single lookup. Your example does not seem to make sense. The first parameter
should be a single value or cell reference. The other 2 should basically
allow you to tell where you want to find it. Check the syntax in help.
Generally it is like: =(LOOKUP(C$206,'v1'!O$3:O$150)).
--
HTH
Richard Choate, CPA

"Jonsson" wrote in message
...
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




"Richard Choate" skrev i meddelandet
...

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

Richard Choate, CPA

"Jonsson" wrote in message
...
Hi,

I have this formula:

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

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

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" skrev i meddelandet
...
And fourth, this thread should be in . . .worksheet.functions, not in
. . .programming.

Alan Beban

Richard Choate wrote:
The lookup function will return one record as a result, based on your
criteria., Therefore there is nothing to add. If you have several
lookups in
a column, you can run a sum on the group of lookups, but you can't sum a
single lookup. Your example does not seem to make sense. The first
parameter
should be a single value or cell reference. The other 2 should basically
allow you to tell where you want to find it. Check the syntax in help.
Generally it is like: =(LOOKUP(C$206,'v1'!O$3:O$150)).
--
HTH
Richard Choate, CPA

"Jonsson" wrote in message
...
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




"Richard Choate" skrev i meddelandet
...

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

Richard Choate, CPA

"Jonsson" wrote in message
...
Hi,

I have this formula:

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

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

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

Jonsson wrote:
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" skrev i meddelandet
...

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

Alan Beban

Richard Choate wrote:

The lookup function will return one record as a result, based on your
criteria., Therefore there is nothing to add. If you have several

lookups in

a column, you can run a sum on the group of lookups, but you can't sum a
single lookup. Your example does not seem to make sense. The first

parameter

should be a single value or cell reference. The other 2 should basically
allow you to tell where you want to find it. Check the syntax in help.
Generally it is like: =(LOOKUP(C$206,'v1'!O$3:O$150)).
--
HTH
Richard Choate, CPA

"Jonsson" wrote in message
...
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$15 0))


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




"Richard Choate" skrev i meddelandet
...


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

Richard Choate, CPA

"Jonsson" wrote in message
...
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