IntermediateHRAbout 7 minutes
Sample data
| Row | A | B | C | D | E |
|---|---|---|---|---|---|
| 1 | Name | Department | Salary | Start date | Rating |
| 2 | Amira Hassan | Finance | 9200 | 2019-03-04 | 4 |
| 3 | Ben Carter | Sales | 7800 | 2021-07-19 | 3 |
| 4 | Chen Wei | Sales | 8100 | 2020-01-13 | 5 |
| 5 | Dina Ali | HR | 7200 | 2022-09-01 | 4 |
| 6 | Emil Novak | Operations | 6900 | 2018-11-26 | 2 |
| 7 | Farah Khan | Finance | 10400 | 2016-05-09 | 5 |
| 8 | Gabriel Silva | Operations | 6500 | 2023-02-14 | 3 |
Steps
Each formula is already filled in and calculated. Edit it and press Run to try your own version. Nothing is saved or uploaded.
Headcount in Sales.
Result
Average salary in Sales.
Result
Total salary bill for Finance.
Result
Highest salary in Finance.
Result
The middle salary for the whole team.
Result
How many people have a rating of 4 or more and pay above 9000?
Result
What to remember
Summaries by group are the heart of reporting. Keep the department name in a cell and refer to it, so one formula works for every team.
Need Something Different? Let’s Talk.
Looking for different features or something built around your workflow? Share your idea with us.