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

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

You need to provide more details.

Biff

"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