Toppers

I did read on another post that zeros may cause the problem. I do have
zeros in the cells E1:E10000

Hope this might help.
--
Richard


"Toppers" wrote:

Assuming you are summing contents of E$1:$P$10000 where other conditions are
meet:

=SUMPRODUCT(--(Data!$A$1:$A$10000=DATE(2007,4,1)),--(Data!$A$1:$A$10000<=DATE(2008,3,31)),--(Data!$D$1:$D$10000="Yes"),--(Data!$B$1:$B$10000="Housing
Building Services")*(Data!$E$1:$P$10000))

"Richard" wrote:

I have another question about a SUMPRODUCT I am using.

I am using Windows XP and Excel 2000.

Here is the formula:

=SUMPRODUCT(--(Data!$A$1:$A$10000=DATE(2007,4,1)),--(Data!$A$1:$A$10000<=DATE(2008,3,31)),--(Data!$D$1:$D$10000="Yes"),--(Data!$B$1:$B$10000="Housing
Building Services")*SUM(Data!$E$1:$P$10000))

This formula needs to SUM a total of number in cells E1:P10000 where there
is a 'Yes' in cells D1:D10000 and 'Housing Building Services' is in cells
B1:B10000.

At the moment the formula seems to be doing a SUM of all numbers in
E1:P10000 and then multiplying that number by 2.

The number should be displaying 18 but instead it is displaying 156.

Any idea where I am going wrong.

Again many thanks for any help with this.

--
Richard