SumProduct
 

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'!D4:D2000),'Payment Entry'!D4:D2000)

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.

SumProduct
 

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).

StephenAccountant wrote:

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'!D4:D2000),'Payment Entry'!D4:D2000)

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

SumProduct
 

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

Dave Peterson wrote:

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).

StephenAccountant wrote:

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'!D4:D2000),'Payment Entry'!D4:D2000)

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

--

Dave Peterson