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
|