Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
locate and SUM values from LOOKUP rows?
I am trying to figure out how to LOOKUP (or MATCH or INDEX or whatever) and
SUM all area values belonging to a certain location value. Excel data information stored in one worksheet as location, area, other stuff . More than one area is recorded for any given location. Other worksheet should show desired location value and summation. Thank you. MaryB XL2003 |