answersLogoWhite

0


Best Answer

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

First put a list of the items in one column and the price paid in the next column. Say you have the prices in column B from row 2 to row 20. At the bottom of the list of prices you would use the SUM function, like this:

=SUM(B2:B20)

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How would you construct an Excel formula to calculate your grocery expenses?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How does a grocery cost estimator work?

There are quite a few grocery cost estimators online, that use information such as the number of people in your household and their ages and genders to calculate what you should be spending on groceries each week. Iowa State University has a calculator available online, as does eHow.


How did the cashier scan and calculate the grocery items?

by the computer


Can you get a grocery cost calculator for your mobile phone?

The company Calcnexus has a grocery cost calculator for your mobile phone. It allows you to make price comparisons, calculate price by unit, and calculate your price with coupons.


How is a grocery cost calculator different than a standard calculator?

A grocery cost calculator is used to estimate and calculate the food cost for a family. Its different than a standard calculator which is used to calculate the answer to math problems.


How much to start a small grocery?

There are lot of expenses associated with starting a small grocery store. These include rent, the cost of inventory, the cost of employees and the cost of insurance. The actual costs will depend on the geographic area and the costs in that region.


What is deductible for 2010?

Kids, Job Interviewing expenses, Work Travel expenses, Everything involving your home, If you kept your grocery receipts i heard you can write most items off this year, Gas mileage on your car, medical bills.


Is there a store that accepts baby formula coupons and does "double coupons"?

Some of your local grocery stores will do this. You will have to go to the grocery stores in your area and see which ones will in fact double coupons.


Does the IRS ever send letters in the mail asking for grocery bills?

If you have taken grocery bills off on your taxes, the IRS could ask for receipts. People may take deductions on business expenses for groceries purchased for a business lunch or dinner.


15 ways to make your food last almost for forever?

Food is one of the biggest recurring expenses we have, why not make the most of what you spend your money on at the grocery store?


How do you calculate a quadratic equation from a computer without using the quadratic formula want an alternative as the quadratic formula is a floating point calculation hence it is slow?

any grocery store will take herbal essences coupons if their either from their store or from the manufacturer. other then that the coupons acceptence all depends on the store it is designated for.


In a grocery store you push a 12.3kg shopping cart with a force of 10.1N. If the cart starts at rest how far does it move in 2.5s (assuming no friction from the floor. Hint calculate the acceleration?

You push a 12.3 kg shopping cart with a force of 10.1 N. a) What is the acceleration of the cart.


The Grocery Game?

Cutting expenses from the monthly budget seems to have become a hobby to some. While certain expenses cannot be negotiated, when it comes to grocery shopping, this often large expense can be slashed substantially if you change your grocery habits. Grocery cost comparison is all the rage today and for good reason. Times are tough, and cutting coupons is an easy way to maintain some control over your budget. Hang on to your weekly grocery circulars and compare sale items. Some stores will match and even double the value of your coupon. You may even find it cost-effective to do your weekly monthly shopping in more than one store. Pick a method that works best for you, and go with it. You may find it time-consuming at first, but the more you do it the easier it will become, and the rewards are many!