Try a free DigiQuick lesson

Test your new skills!

Now that you’ve learned about the Sumif formula, try this activity to put your new skills into action!

First of all, download the activity spreadsheet by clicking on the blue button, then save that spreadsheet into your OneDrive.

Then, calculate the individual mileage total for each person, using the Sumif formula.

Now, watch the explanation video to watch us complete the task and make sure you feel confident with every skill.