If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|