I've got a spreadsheet set up with

X = a defined type

y = a defined location

Z = a number pertinent to the location and type.


I have it set up in such a way that I can select my location in a cell
A1 with data validation and then for each type I will get a number that
relates to the selected location.

so my formula is along the lines of...

A2. A10 are lists of types

and B2 will have -=sumproduct((x=A2)*(y=$A$1),z)-

What I want to know is if there is any way I can have the formula
return the amount for all locations as an option, without creating a
separate formula omitting the -y=$A$2- part.

In other words is there some sort of text string which excel will see
as a match for all the locations I have listed?

hope this explains what I'm trying to achieve and thanks for any
assistance out there.

tm


--
Timmy Mac1
------------------------------------------------------------------------
Timmy Mac1's Profile: http://www.excelforum.com/member.php...o&userid=15188
View this thread: http://www.excelforum.com/showthread...hreadid=504885