It is calculate the sum of the products of corresponding numbers in one or more ranges, it 's use MS Excel powerful SUMPRODUCT function.
Syntax :- =SUMPRODUCT(ARRAY1,[ARRAY2]........) ENTER
Explanation:-
=SUMPRODUCT(F2:F6,H2:H6) Enter
How came these amount
The SUMPRODUCT function performs this calculation: (2 * 1000) + (4 * 250) + (4 * 100) + (2 * 50) = 3500.
No comments:
Post a Comment
if you have any doubt let me known will
give suggestion in this site
Thank you so much