The Grand
Total
4. Lastly, go
to the Pigs sheet
Select
cell E2
Hit Enter
on your keyboard so Excel will calculate.
5. You
will be taken back to cell C2 in the Summary spreadsheet.
6. AutoFill this equation and we’ve got a
formula that adds all of the sales for each product. Well done.