How will the following formula be updated if it is copied RIGHT one cell?
=SUMPRODUCT($A$1:$A$10, C$1:C$10)
Expert Answer
Solution :
If the formula is copied by one cell to right, the formula will be
=SUMPRODUCT($A$1:$A$10, D$1:D$10)
How will the following formula be updated if it is copied RIGHT one cell?
=SUMPRODUCT($A$1:$A$10, C$1:C$10)
If the formula is copied by one cell to right, the formula will be
=SUMPRODUCT($A$1:$A$10, D$1:D$10)