Hi All,

I'm trying to find a way to calculate occupancy for a dorm base on various
criteria. Currently, the information is sorted by Dorm# and Room# which is
fine as there are multiple dorms on the worksheet.

Example

Column A Column B Column C
Dorm # Room # Age
1304 115 21
1304 115 22
1304 116 21
1304 117 22
1304 118 23
1304 118 21

I have a range from age 21-25 years old and want to determine the number of
folks in each age group with and without a room mate. I'm not so much
concerned that those with room mates have someone the same age as them in the
rooms but if the room mate is a different age, each variable representing the
age group would receive a mark in the Double Occupancy cell. In the example
above it would calculated in this manner:

Double Occupancy Single Occupancy
21 - 2 1
22 - 1 1
23 - 1 0

I've found a way to pull the information only if the Dorm=1304 and Room <300
now I just need to pull the other information as indicated above. Any help?

Chaz