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

locate and SUM values from LOOKUP rows?
 

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

locate and SUM values from LOOKUP rows?
 

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