I've tried using this formula to count data from colum F where data from
column E is between December 1, 2005 and January 1, 2006. I keep getting
the #VALUE!
I've tried different scenarios with different operators and functions
but to no avail.

=SUMPRODUCT(--('mail-data'!F2:F1002)if('mail-data'!$E$2:$E$1002DATE(2005,11,30))*--('mail-data'!$E$2:$E$1002<DATE(2006,1,1)))


--
archivesgirl
------------------------------------------------------------------------
archivesgirl's Profile: http://www.excelforum.com/member.php...o&userid=31827
View this thread: http://www.excelforum.com/showthread...hreadid=515817