Hi!

Assumptions:

Dates in A1:A100
Names in Z1:Z100

is it possible to enter date ranges as criteria in excel

Use 2 cells to hold the date range and a cell to hold the name:

B1 = start date
C1 = end date
D1 = name

=SUMPRODUCT(--(A1:A100=B1),--(A1:A100<=C1),--(Z1:Z100=D1))

Biff

"mhall5" wrote in
message ...

Does anyone know what is the best way to count values based on multiple
criteria? I am trying to count each instance where based on a certain
range of dates, a person name shows up. What would be the best way to
do this. I have tried countif, count(if(, Sumif, array formulas,
sumproduct,etc. All of these to no avail. If anyone has any suggestions
or thinks I am overlooking something please let me know. THe colums
which contain the dates and names of persons are not ajacent. Any name
can be corresponded with any date, even identical. Please help!!! Also
is it possible to enter date ranges as criteria in excel


--
mhall5
------------------------------------------------------------------------
mhall5's Profile:
http://www.excelforum.com/member.php...o&userid=30087
View this thread: http://www.excelforum.com/showthread...hreadid=497726