Either,

=SUMIF(rng1,"value",rng2)

or maybe

=SUMPRODUCT(--(rng1="value1"),--(rng2=number2),rng3)


--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Minx" wrote in message
...
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