Quick Calcs - Grouping

Fastest way to do SUMIFS, AVERAGEIFS, and COUNTIFS


One of the most common analysis that people do when they have a CSV or Database is to analyze total (sum or count) or average by group. In traditional spreadsheets like Excel/Sheets, the way to do this is:

  1. Copy the category and paste it into a new column (10+ clicks)

  2. Remove the duplicates (10+ clicks)

  3. Write a SUMIF COUNTIF or AVERAGEIF formula (10+ clicks)

  4. Then drag it down (10+ clicks)

In Subset, we can do this much faster and more intuitively. All you have to do is:

  1. Click quick calcs and select the analysis you want (3 clicks)

  2. Select the column you want to group by (1 click)

  3. Select the column you want to do the analysis on (1 click)

These steps automatically takes the column you want to group by and removes duplicates. Then it takes the formula and automatically applies it for every grouped item. This block also automatically updates as the inputs change.

Last updated