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

 

Subtotal the Spreadsheet

What is the sum of all the products sold?  Here are the steps to create a total for all of the daily revenue.

 

Try it: AutoSum the Revenue

Select Cell E21

Go to the Home Ribbon

Click on the AutoSum Function

 

Excel will enter the following equation:

=SUM(E2:E20)

 

Click ENTER on your keyboard and Excel will calculate the Sum.

Home ->Editing ->AutoSum