How to Create a Spreadsheet for
your Groceries
·
1st
Step – Type groceries and prices into excel spreadsheet like the table example
below.
|
Itinerary (column A, row 1) |
Price (Column B, row 1) |
|
Monday |
|
|
Meat |
$6.58 |
|
Vegetable |
$1.00 |
|
Side Dish
|
$2.50 |
|
Drink |
$2.00 |
|
Dessert |
$5.43 |
|
Monday total |
$49.01 |
|
Tuesday |
|
|
Meat |
|
|
Vegetable |
|
|
Side Dish
|
|
|
Drink |
|
|
Dessert |
|
|
Tuesday total |
|
|
|
|
|
Total for all days |
|
·
2nd
Step – Write formulas to get the total for each day:
o
Formula
for adding: =SUM(column row+ column row)
=SUM(C2+B3)
·
3rd
Step – Write formula to add all the
daily totals