Following video demonstrates first the traditional way to do that and then same by using SUMPRODUCT()-function:
Monday 28 January 2013
How to use Excel's SUMPRODUCT()-function
An easy way to sum products of corresponding numbers in several arrays is to use Excel's SUMPRODUCT()-function. It takes one or more arrays as parameters and calculates sum of products.
Following video demonstrates first the traditional way to do that and then same by using SUMPRODUCT()-function:
Following video demonstrates first the traditional way to do that and then same by using SUMPRODUCT()-function:
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment