Wow, 2 quick posts with the same answer. Great minds think alike.
Unfortunately, I am not getting my data to cooperate. Perhaps I can be more
specific:

I have two tabs in one workbook. The first tab contains columnar data with
the left-most column containing a location. Several columns over, it also
contains a column I want to contain the sum of all equipment associated with
a given location.

The second tab contains columnar data with the left-most column containing
locations also; however, each location is listed multiple times - once for
each type of equipment located there. The first tab needs to capture the
total cost for each location, which consists of multiple lines that are
various costs.

Does this help?


"dawgfan" wrote:

I have a huge spreadhset (and a deadline!) that VLOOKUP will find several
matches for the lookup_value. Each may have a diferent value at the
range_lookup. I need the formula to return a sum of all values. Please help
me figure out how to do it! Thanks very much!