Sumproduct error

F

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
 
M

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
 
D

dan dungan

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

Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top