Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and SUM
I am working with a spreadsheet where I need to lookup a text value in one
column and sum the numbers appearing in another column. Is there a way to combine these two functions? I've figured out how to do the lookup, but not how to sum the results. It appears that the lookup stops at the first match. Any suggestions would be appreciated. Thanks! Rebecca |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and SUM
SUMPRODUCT may help you. Please post some more details like what are your
ranges etc. "Rebecca" wrote in message ... I am working with a spreadsheet where I need to lookup a text value in one column and sum the numbers appearing in another column. Is there a way to combine these two functions? I've figured out how to do the lookup, but not how to sum the results. It appears that the lookup stops at the first match. Any suggestions would be appreciated. Thanks! Rebecca |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and SUM
Try this:
Sum column B where the corresponding cells in column A = "text". =SUMIF(A1:A100,"text",B1:B100) Better to use a cell to hold the "text" : D1 = text =SUMIF(A1:A100,D1,B1:B100) Replace "text" with the actual text string you're looking for. -- Biff Microsoft Excel MVP "Rebecca" wrote in message ... I am working with a spreadsheet where I need to lookup a text value in one column and sum the numbers appearing in another column. Is there a way to combine these two functions? I've figured out how to do the lookup, but not how to sum the results. It appears that the lookup stops at the first match. Any suggestions would be appreciated. Thanks! Rebecca |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and SUM
You may be needing an Array Formula... that is deep water, but well worth
learning. In addition to Excel Help on Array Formulas, I recommend studing it in the "Excel 2007 Bible" by John Walklenbach. (There are editions on earlier Excel versins where Array Formulas exist, too.) Kim W. "Rebecca" wrote: I am working with a spreadsheet where I need to lookup a text value in one column and sum the numbers appearing in another column. Is there a way to combine these two functions? I've figured out how to do the lookup, but not how to sum the results. It appears that the lookup stops at the first match. Any suggestions would be appreciated. Thanks! Rebecca |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and SUM
This worked perfectly. Thanks very much.
"T. Valko" wrote: Try this: Sum column B where the corresponding cells in column A = "text". =SUMIF(A1:A100,"text",B1:B100) Better to use a cell to hold the "text" : D1 = text =SUMIF(A1:A100,D1,B1:B100) Replace "text" with the actual text string you're looking for. -- Biff Microsoft Excel MVP "Rebecca" wrote in message ... I am working with a spreadsheet where I need to lookup a text value in one column and sum the numbers appearing in another column. Is there a way to combine these two functions? I've figured out how to do the lookup, but not how to sum the results. It appears that the lookup stops at the first match. Any suggestions would be appreciated. Thanks! Rebecca |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
VLOOKUP and SUM
You're welcome. Thanks for the feedback!
-- Biff Microsoft Excel MVP "Rebecca" wrote in message ... This worked perfectly. Thanks very much. "T. Valko" wrote: Try this: Sum column B where the corresponding cells in column A = "text". =SUMIF(A1:A100,"text",B1:B100) Better to use a cell to hold the "text" : D1 = text =SUMIF(A1:A100,D1,B1:B100) Replace "text" with the actual text string you're looking for. -- Biff Microsoft Excel MVP "Rebecca" wrote in message ... I am working with a spreadsheet where I need to lookup a text value in one column and sum the numbers appearing in another column. Is there a way to combine these two functions? I've figured out how to do the lookup, but not how to sum the results. It appears that the lookup stops at the first match. Any suggestions would be appreciated. Thanks! Rebecca |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
IF(AND(val1=VLOOKUP( );val2>=VLOOKUP( );val2<=VLOOKUP( );VLOOKUP( | Excel Worksheet Functions | |||
Vlookup info being used without vlookup table attached? | Excel Worksheet Functions |