I am attempting to create a formula where column "C" has locations
represented by numbers. Column "F" is estimated completion dates.
Column "K" is the actual completion date. I would like to count the
dates in (column "K") by location (column "C"). And by month (column
"F"). I tried the following formula but it returns 0. The correct
answer is 6. Could someone please take a look at this and tell me what
I am doing wrong?

SUMPRODUCT(--(C2:C465=1700),--(F2:F465=DATE(2005,3,1)),--(F2:F465<=DATE(2005,3,31)),--(ISNUMBER(K2:K465)))


--
was
------------------------------------------------------------------------
was's Profile: http://www.excelforum.com/member.php...o&userid=20211
View this thread: http://www.excelforum.com/showthread...hreadid=374096