Total expenditure by person and type
Having the number of reports filed for each person and expense type is useful, but having the total expenditure for each person and expense type would provide key evidence for any conclusions.
In this exercise, you'll do just that!
This exercise is part of the course
Data Analysis in Google Sheets
Exercise instructions
- In
H14:K16, calculate the sum of expenses for each person/expense type pair.
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise