Sumproduct error

[formcreator]

Hello,
I have 2 ranges A1:A5 and B1:B5 and in column C I am trying to do a
sumproduct and I am entering the formula in C1 sumproduct(A1:A5,B1:B5) it
works fine in the cell C1 but when I copy the formula down to the cells C2
throgh C5. The formula becomes sumproduct(A1:A6,B1:B6) and I get the error
Formula omits adjacent cells.

How do I resolve this error.

Thank You
Shri

 

[Mike H]

Hi,

It's just Excel trying to be too clever. Try

Tools|Options|Error checking

Select the level of error checking your require

Mike

 

[dan dungan]

That must be for some version other than 2000, right? I couldn't find
"error checking" under options.

Dan