answersLogoWhite

0


Best Answer

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

User Avatar

Wiki User

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

Wiki User

11y ago

In one column type in the headings of the items and in the cell in the column next to each of those headings type in the value. Then at the bottom of the list of values use the SUM function to total them up. So say you have values in cells B2 through to B20, then in cell B21 you could have the following formula:

=SUM(B2:B20)

This answer is:
User Avatar

User Avatar

Wiki User

9y ago

The standard way would be to have them in a column and then use the SUM function to total them. So for example, if they were in column C, from cell C2 to C20, you would use the following SUM function:

=SUM(C2:C20)

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you make a cost table of the money you have to pay with Microsoft Excel?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

How much does Microsoft Excel cost?

That depends on what version you are buying and where you are in the world. You can check for prices locally or online.


Does Microsoft Silverlight cost money to install?

Microsoft Office does not cost money to install. However, you will need to purchase a valid license in order to use the software. You can buy a license from Microsoftprokey or from a third-party retailer.


Where can I learn MS Excel for free?

There are lots of websites with information on Excel. You would also get a lot of information in the Excel category on WikiAnswers. There are online tutorials. You won't always understand them, and there isn't someone there to explain them. A better way of learning Excel is to get someone to show you. A course will cost you, but someone that you know who is good at Excel could show you.


How much Microsoft points does it cost for halo wars?

You can't buy Halo Wars with Microsoft points.You have to use real money.


I'm in charge of upgrading the computer software in my office. Is Microsoft Excel the best spreadsheet software to use?

Yes, Microsoft Excel will be the best and most convenient spreadsheet software for your employees, especially if that's what they've used in the past. Actually, you should just add the entire Microsoft Office package instead of just the spreadsheet software. It'll cost a little more, but it will be better for you in the long run.


You have Microsoft Excel 2007 version you need to have your total cost column to calculate the cost from two columns How do you do this procedure?

Use the SUM function and separate each range with a comma.EXAMPLE:=SUM(A1:A23,B1:B23)


How can I receive help with Microsoft cloud computing?

Go to the Microsoft site and experts will tell you how to have Cloud in your PC to save everything. It should not cost money to ask them about advice.


Has anyone got a working Microsoft point code generator?

i dont but i heard they are hard to get and cost a lot of money


What formula in Microsoft excel would compute a total cost with tax?

=SUM(A1:A12)*.065 [assumes A1:A12 contains the purchased items and the tax rate is 6.5%]


How much 3600 Microsoft points cost?

3600 Microsoft points cost £31.87


How much money does it cost to get 300 Microsoft points?

To get 300 Microsoft points we should pay lesser than 21.218 dollars (USA) and in India we have to pay lesser than 1000 rupees


Does converting your Microsoft office programs always cost money?

Yes it does , but it depends on what your downloading to your computer but becarfull it may hurt your computer