VLOOKUP and SUM

[Rebecca]

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

 

[Gaurav]

SUMPRODUCT may help you. Please post some more details like what are your
ranges etc.

 

[T. Valko]

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.

 

[KIM W]

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]

This worked perfectly. Thanks very much.

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.

 

[T. Valko]

You're welcome. Thanks for the feedback!