You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Johnny" wrote in message
...
That worked. Thank you so much.

I accidently click on "No" to the question on whether your post was
helpful.
Sorry about that. Your post was very very helpful.

"T. Valko" wrote:

Try this...

A1 = lower date boundary
A3 = upper date boundary
A3 = some city

In the formula:

City refers to the range that contains the city names
Emp refers to the range that contains the employee names
Date refers to the range that contains the dates

Array entered** :

=SUM(IF(FREQUENCY(IF(City=A3,IF(Date=A1,IF(Date<= A2,MATCH(Emp,Emp,0)))),ROW(Emp)-MIN(ROW(Emp))+1),1))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the
SHIFT
key then hit ENTER.

Assumes there are no empty cells in the Employee range.

--
Biff
Microsoft Excel MVP


"Johnny" wrote in message
...
I've scanned through related posts with no luck. I have a production
spreadsheet with several columns of data. Here are the relevant
columns
(3)
for my question:

City Employee Date


I need to count the distinct number of employees based on the city and
a
date range. Let's say that the date range is 1/1/09 to 1/31/09 and is
in
cells A1 and A2 respectively.

Cities and Employees are duplicated multiple times. What I want to
end
up
with is the count of the number of emloyees for a particular City for
a
given date range.


.