Simple AND condition

In this exercise we will perform our first sum aggregation on a large dataset, using the relevant functions and criteria!

You can complete this exercise on DataCamp using in-browser Excel, or locally if you have Excel installed.

Database functions are very useful when working with transactional data or event data. They allow for multiple, even complex aggregation conditions in a neat structure of these functions' syntax.

As a reminder, below we display the syntax of one of these database functions, DSUM( ) and a brief recap on Criteria Table:

Our criteria for this exercise: Consumer Sales between 1 Jul 2014 and 1 Sep 2014.