SumProduct

[StephenAccountant]

Hey,

i've got two identical work books (one for 2007 and one for 2008)

I have a sumproduct formula that works in the 2007 workbook but not in the
2008 workbook. I get a #value error in the 2008 workbook.

The formula is:

=SUMPRODUCT(--(('Payment Entry'!C4:C2000+30)<E2),--('Payment
Entry'!F4:F2000>='Payment Entry'!D42000),'Payment Entry'!D42000)

It is exactly the same formula as in my 2007 workbook.

I've double checked that my sheet names are identical and that my columns
are identical and that my cell references are identical. Can't work out the
problem.

 

[Dave Peterson]

I'd look for any text cells in those ranges (C4:c2000 first, since you're doing
arithmetic with them).

Remember to look in hidden rows (autofiltered or manually hidden).

 

[Dave Peterson]

And then I'd look in all the ranges for errors.

I'd look for any text cells in those ranges (C4:c2000 first, since you're doing
arithmetic with them).

Remember to look in hidden rows (autofiltered or manually hidden).