|
sum of lookup
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 |
sum of lookup
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 |
sum of lookup
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 |
sum of lookup
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 |
sum of lookup
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 |
sum of lookup
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 |
sum of lookup
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 |
| All times are GMT +1. The time now is 10:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com