Course Solutions Uncategorized (Answered) : How will the following formula be updated if it is copied RIGHT one cell? =SUMPRODUCT($A$1:$A$10, C$1:C$10)

(Answered) : How will the following formula be updated if it is copied RIGHT one cell? =SUMPRODUCT($A$1:$A$10, C$1:C$10)

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)

Leave a Reply

Your email address will not be published. Required fields are marked *

Related Post