3 sheets tagged with "aggregating":

An example of using the powerful Aggregate function to aggregate data in worksheets.

Aggregate provides an easy way of summarising data from one worksheet into another worksheet. It is similar to, but more powerful than, the pivot tables you might be familiar with from Excel and other spreadsheets.

This example takes a set of transactions in the 'Data' worksheets and puts several different summaries into the other worksheets.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.

An example of using the powerful Aggregate function to achieve a similar effect to pivot tables you might be familiar with from Excel and other spreadsheets.

The first sheet 'donations', is purely data I typed in.

The second sheet is generated using a few lines of post-formula usercode, which invokes Aggregate. This calculates the count, the total and the average donation, all by country.

I used three built-in functions to aggregate the values in the pivot table (len, SUM and AVERAGE.)

It also adds a column to the pivot table which lists the names of all people who donated from a particular country.

Row and column level formulae allow you to apply a formula to every row or column in a worksheet. They are extremely useful for removing duplication and avoiding certain kinds of common errors in spreadsheets.

You can also use them in surprising ways; like combining them with list comprehensions to do data aggregation.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.