Excel: Legs, Eggs and Pigs Page 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17

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.

 

DONE