Thread
:
Can someone check this formula please?
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
Posts: n/a
Can someone check this formula please?
There 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$ 3510))
--
Don Guillett
SalesAid Software
"y_not" wrote in
message ...
Hi,
I am using the following formula: -
=SUMPRODUCT((Names!$A$2:$A$351="01/03/2006")*(Names!$E$2:$E$3510))
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:
http://www.excelforum.com/member.php...o&userid=19947
View this thread:
http://www.excelforum.com/showthread...hreadid=541934
Reply With Quote