Calculate a Total

Again, log in to Purple Mash and launch 2Calculate in formula mode. Alternatively, you can load your saved work from last lesson.

Open this video in a new tab

Enter this list of PE equipment and their prices for Mr Myers. Take care to enter them in the cells shown in the screen video. Take turns with your partner.

  • 16 Footballs £35
  • 14 Netballs £32
  • 20 Hoops £40
  • 48 Cones £75

Open this video in a new tab

How much money does Mr Myers need to spend in total?


The Easy Way

Now let’s look at an easier way to calculate it. There are two ways to do this in 2Calculate.

With the sum cell

Open this video in a new tab

With a formula

Open this video in a new tab

Save

Save your work as PE Kit in your My Work folder.