Adding a range criteria (i.e. ages) to an array - best way?

[joemax]

Hello,
I have an excel spreadsheet list of people which includes multiple characteristics (city, age, name, ect) and would like to count the number of individuals who live in city x and are also within a specific age group (i.e. 25-40) - is it possible to include a range within an array or is there an easier way to do this?
Thanks, Joe

 

[FormR]

Maybe like this:

Excel Workbook
	A	B	C
1	Name	City	Age
2	Fred	Y	10
3	John	Y	18
4	Jim	X	26
5	Tony	Y	39
6	Jenny	X	40
7	Sharon	X	17
8
9		XL2007+	2
10		All Versions	2
Sheet1