software

Hi,

I am using the following formula: -

=SUMPRODUCT((Names!$A$2:$A$351=quot;01/03/2006quot;)*(Names!$E$2:$E$351gt;0))

the idea being that it checks A1 to A351 for the date (in this case
01/03/2006) and then returns the total number of occurances.

Problem is ... it don't work!! (Obvious being as I wrote it!!)

Can anyone help, please?

Many thanks

Tony--
y_not
------------------------------------------------------------------------
y_not's Profile: www.excelforum.com/member.php...oamp;userid=19947
View this thread: www.excelforum.com/showthread...hreadid=541934There are several ways to fis but the easiest way, for you, would be to put
your date in a cell and use
=SUMPRODUCT((Names!$A$2:$A$351=b1)*(Names!$E$2:$E$ 351gt;0))

--
Don Guillett
SalesAid Software

quot;y_notquot; gt; wrote in
message ...
gt;
gt; Hi,
gt;
gt; I am using the following formula: -
gt;
gt; =SUMPRODUCT((Names!$A$2:$A$351=quot;01/03/2006quot;)*(Names!$E$2:$E$351gt;0))
gt;
gt; the idea being that it checks A1 to A351 for the date (in this case
gt; 01/03/2006) and then returns the total number of occurances.
gt;
gt; Problem is ... it don't work!! (Obvious being as I wrote it!!)
gt;
gt; Can anyone help, please?
gt;
gt; Many thanks
gt;
gt; Tony
gt;
gt;
gt; --
gt; y_not
gt; ------------------------------------------------------------------------
gt; y_not's Profile:
gt; www.excelforum.com/member.php...oamp;userid=19947
gt; View this thread: www.excelforum.com/showthread...hreadid=541934
gt;
Try this:
=SUMPRODUCT((Names!$A$2:$A$351=DATE(2006,3,1))*(Na mes!$E$2:$E$351gt;0))

HTH
--
AP

quot;y_notquot; gt; a écrit dans le
message de news: ...
gt;
gt; Hi,
gt;
gt; I am using the following formula: -
gt;
gt; =SUMPRODUCT((Names!$A$2:$A$351=quot;01/03/2006quot;)*(Names!$E$2:$E$351gt;0))
gt;
gt; the idea being that it checks A1 to A351 for the date (in this case
gt; 01/03/2006) and then returns the total number of occurances.
gt;
gt; Problem is ... it don't work!! (Obvious being as I wrote it!!)
gt;
gt; Can anyone help, please?
gt;
gt; Many thanks
gt;
gt; Tony
gt;
gt;
gt; --
gt; y_not
gt; ------------------------------------------------------------------------
gt; y_not's Profile:
gt; www.excelforum.com/member.php...oamp;userid=19947
gt; View this thread: www.excelforum.com/showthread...hreadid=541934
gt;

Works a treat--
y_not
------------------------------------------------------------------------
y_not's Profile: www.excelforum.com/member.php...oamp;userid=19947
View this thread: www.excelforum.com/showthread...hreadid=541934The specific reason why your formula did not work is because quot;01/03/2006quot; is
being evaluated as a TEXT string and not a numeric DATE.

Don's suggestion is the best option to use but here are a couple of others:

=SUMPRODUCT((Names!$A$2:$A$351=--quot;2006/01/03quot;)*(Names!$E$2:$E$351gt;0))

=SUMPRODUCT((Names!$A$2:$A$351=DATE(2006,1,3))*(Na mes!$E$2:$E$351gt;0))

Biff

quot;y_notquot; gt; wrote in
message ...
gt;
gt; Works a treat
gt;
gt;
gt; --
gt; y_not
gt; ------------------------------------------------------------------------
gt; y_not's Profile:
gt; www.excelforum.com/member.php...oamp;userid=19947
gt; View this thread: www.excelforum.com/showthread...hreadid=541934
gt;