LOOKUP AND SUM RESULTS

[thillman]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I need to perform a lookup from an unsorted text column and return a sum of the corresponding amounts found in another column. Is this possible? If so, what is the formula?

 

[Bob Greenblatt]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I need to perform a lookup from an unsorted text column and return a sum of
the corresponding amounts found in another column. Is this possible? If so,
what is the formula?

If column A contains the unsorted text items, and column B contains values
associated with those text items, you can sum them with an array formula:
=sum(("xxx"=$A:$A)*$B:$B)
Press control-shift-enter to enter the array formula.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I need to perform a lookup from an unsorted text column and return a sum of
the corresponding amounts found in another column. Is this possible? If so,
what is the formula?

One way:

=SUIMF(A:A, "target text", B:B)

where A:A contains the text and B:B contains the values.