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