Monday, 9 December 2013

Using the SUMPRODUCT function to sum multiple criteria / advanced cell references

By , Director, Naturally Sales Ltd.

We guide you through creating a two-dimensional table to display information from large data sets.

In the first part, we’ll familiarize ourselves with a useful advanced lookup formula: SUMPRODUCT, then we’ll learn how we can save time populating tables by using a combination of absolute and relative references.

These are best looked at in an example, so you’ll find details in a file which you can download just here.  


www.nsales.co.uk/excel-examples/Populating-a-table-with-absolute-and-relative-references-using-SUMPRODUCT.xlsx

No comments:

Post a comment