Question

if the range a1:a4 consists of the values 1,2,3,4 and the range b1:b4 consists of the values 9,8,7,6, what is the value of the sumproduct(b1:b4, a1:a4)?

Answer 1

Answer: 70

Explanation:

sumproduct(b1:b4,a1:a4)=(1)(9)+(2)(8)+(3)(7)+(4)(6)=9+16+21+24=70

sumproduct(b1:b4,a1:a4)=70