| Spreadsheets |
To calculate the total number of CD's left in stock you need to
type in
the following formula into cell D7: =SUM(D2:D6)
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Artist | Title | Price | Number | Running Total | Sold | Sales |
| 2 | Hell Zombies | I'm upset! | £14.99 | 2 | 55 | 53 | £794.47 |
| 3 | M-Psink! | I Want U Baby | £13.99 | 5 | 27 | 22 | £307.78 |
| 4 | Bushwacker | Ibiza Chill | £12.99 | 3 | 45 | 42 | £545.58 |
| 5 | The Squires | Dublin Diaries | £9.99 | 1 | 22 | 21 | £209.79 |
| 6 | Mr TNT | Garage Hits | £9.99 | 0 | 12 | 12 | £119.88 |
| 7 | Totals | 11 |
