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

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

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

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

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

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