locate and SUM values from LOOKUP rows?

[Guest]

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

 

[Bob Phillips]

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)

 

[Biff]

You need to provide more details.

Biff