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.

No comments:

Post a Comment