Using Microsoft Excel to auto-calculate totals and subtotals
Creating a budget for a project, or an actual house is very important. However, it doesn't have to be complicated. Using Microsoft Excel is an excellent tool to create spreadsheets, such as a budget. If your budget requires subtotals to be added up, you can follow this tutorial to make it work for you.
1. First, you need a list of materials.
Go to cell A1, and type in the name of one of your materials. Then, go down to A2 and type in another material. Keep going down the cells until all materials are covered.
In my example, I am using elements from the periodic table as materials.
1. First, you need a list of materials.
Go to cell A1, and type in the name of one of your materials. Then, go down to A2 and type in another material. Keep going down the cells until all materials are covered.
In my example, I am using elements from the periodic table as materials.
2. You need to input the individual price per unit of that material. For example, carbon is 15 dollars per atom. So, go to C1 and type in the price per unit of the corresponding material. Repeat until all materials have a price.
3. You need to input the quantity needed of that specific material. For example, we need 3 carbon atoms for this particular project. So, go to E1 and type in the quantity needed for the corresponding material. Repeat until all materials have a quantity.
4. Now we need to make a sub-total column. Go to G1 and click it. Now, go to the Formulas tab and click "Insert Function". Select Product. In the place where it says "Number1", type in the two cells you need to multiply by each other. In this case, you would type in "C1:E1" and then press enter. Now your first cell has a subtotal.
5. Next, right click the cell you just sub-totaled (G1). Click "Copy" and then drag your mouse down to the bottom (G13). In the highlighted blue area right click, and select "Formulas" under paste options. Now you have subtotals for all of your materials! Hooray!
5. Next, right click the cell you just sub-totaled (G1). Click "Copy" and then drag your mouse down to the bottom (G13). In the highlighted blue area right click, and select "Formulas" under paste options. Now you have subtotals for all of your materials! Hooray!
6. For the grand total, go 2 cells beneath the last subtotal and click it. Go to the "Formulas" tab and click "Insert Function". Click "SUM" and make sure the values in "Number1" match the cells that the subtotals encompass. In this case, the values in "Number1" should be G1:G13. Click OK and you will have your grand total.
I hope this guide helped you in making Microsoft Excel auto-calculate subtotals and totals, and in using Microsoft Excel to make a budget altogether. Thank you for relying on my tutorial for your informational needs.