software

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$1002gt;DATE(2005,11,30))*--('mail-data'!$E$2:$E$1002lt;DATE(2006,1,1)))--
archivesgirl
------------------------------------------------------------------------
archivesgirl's Profile: www.excelforum.com/member.php...oamp;userid=31827
View this thread: www.excelforum.com/showthread...hreadid=515817archivesgirl,

For a simple count, you can ignore column F:

=SUMPRODUCT(('mail-data'!$E$2:$E$1002gt;DATE(2005,11,30))*('mail-data'!$E$2:$E$1002lt;DATE(2006,1,1)))

But if you have a criteria for column F, you would add that like so:

=SUMPRODUCT(('mail-data'!$F$2:$F$10=quot;Fredquot;)*('mail-data'!$E$2:$E$10gt;DATE(2005,11,30))*('mail-data'!$E$2:$E$10lt;DATE(2006,1,1)))HTH,
Bernie
MS Excel MVPquot;archivesgirlquot; gt; wrote in message
news:archivesgirl.23ow61_1140710408.1027@excelforu m-nospam.com...
gt;
gt; I've tried using this formula to count data from colum F where data from
gt; column E is between December 1, 2005 and January 1, 2006. I keep getting
gt; the #VALUE!
gt; I've tried different scenarios with different operators and functions
gt; but to no avail.
gt;
gt; =SUMPRODUCT(--('mail-data'!F2:F1002)if('mail-data'!$E$2:$E$1002gt;DATE(2005,11,30))*--('mail-data'!$E$2:$E$1002lt;DATE(2006,1,1)))
gt;
gt;
gt; --
gt; archivesgirl
gt; ------------------------------------------------------------------------
gt; archivesgirl's Profile: www.excelforum.com/member.php...oamp;userid=31827
gt; View this thread: www.excelforum.com/showthread...hreadid=515817
gt;