Can someone check this formula please?

Giganews Newsgroups
Subject: Can someone check this formula please?
Posted by:  y_not (y_not.27sypy_1147618801.1217@excelforum-nospam.com)
Date: Sun, 14 May 2006

Hi,

I am using the following formula: -

=SUMPRODUCT((Names!$A$2:$A$351="01/03/2006")*(Names!$E$2:$E$351>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:http://www.excelforum.com/member.php?action=getinfo&userid=19947
View this thread:http://www.excelforum.com/showthread.php?threadid=541934

Replies