locate and SUM values from LOOKUP rows?

M

Minx

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
 
B

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)
 
Top