eHow launches Android app: Get the best of eHow on the go.
(0 Ratings)
How to Record an Excel Macro
How to Add 2 Cells in Excel
How to Sum a Column or Row of Excel Cells
How to Insert a Row or Column in an Excel Spreadsheet
How to Sort a Row or Column in Excel
How to Create a Bar Graph From an Excel Spreadsheet
How to Use Provided Excel Formulas
How to Use Subtotals & Totals in an Excel Spreadsheet
How to Decide When to Use Worksheets & Workbooks in Excel
How to Add or Delete an Excel Worksheet
How to Rename an Excel Worksheet
How to Format Cell Numbers in Excel
How to Align Text in Excel Cells
How to Add a Background Color or Pattern to Excel Cells
How to Protect Excel Cells From Modification
How to Format Rows & Columns in Excel
How to Add Headers & Footers to Excel Documents
How to Add a Custom Menu to an Excel Toolbar
How to Define Cell Names in Excel
How to Define Cell Ranges in Excel
How to Use Cell Ranges in Excel Formulas
How to Use the AutoFill Function in Excel
How to Use the Freeze Pane Command in Excel to Create Static Headings
How to Save an Excel Worksheet as HTML
How to Create a Spreadsheet Template in Excel
How to Make a Circle Graph With Excel
How to Create a Message Box in Excel VBA
In order to make a formula in Excel, type in an equal sign and go to the "FX" button in order to select "S… More
Creating an Excel formula in Microsoft Office is a great way to perform mathematical calculations based on… More
Creating a formula in Excel 2003 is a great way to perform mathematical calculations and basic math using … More
Microsoft Excel is a powerful tool for analyzing data. The Forecast function provides users with a way of … More
Spreadsheet software offers very useful tools for both business and home applications where users are able… More
How to use Budget Formulas in this free series of personal finance video from our professional Certified P… More
There are two functions to use when calculating APR in Microsoft Excel. Use "PMT" and "Rate" functions in … More
VLookup is an Excel formula that allows a range of cells to be searched through vertically, as opposed to … More
After inserting data into Microsoft Excel, put the cursor into the desired cell and find the VARP function… More
Get totals and subtotals in an Excel spreadsheet by using the auto sum function on the toolbar menu and sp… More
Microsoft Excel formulas can be used to take the sum or average of a set of data by typing an equal sign i… More
Use provided formulas in Excel by selecting the drop down menu from the toolbar next to the auto sound fun… More
Excel users can show formulas by clicking on a cell, which makes the formula appear in a text window. Lear… More
Summary: Get totals and subtotals in an Excel spreadsheet by using the auto sum function on the toolbar menu and specifying which cells are being added. Add totals and subtotals with Excel with tips from an assistant certified public accountant in this free video on Microsoft Excel.
Amar Enhsaihan is an assistant certified public accountant (CPA) and works with Excel applications everyday on his job.read more
"Hi, I'm Amar Enhsaihan. I'm going to show you how to use subtotals and totals in Excel. Here in my example I have a receipt at the grocery store. I have apples, butter, eggs and then subtotal. I will just use auto sum function at the menu, tool bar menu, click sum, it sums it up. And I have a formula for tax here and then I want to total it, then I just click sum again. This time, it doesn't know which one is to sum, so I'm just going to specify it for Excel and then click enter, and I have the total. So here is the subtotal, sums everything up and then here's the total, sums just the subtotal and tax. And that's how you create subtotals and totals in Excel. I'm Amar Enhsaihan, thank you for watching."
eHow Article: How to Use Subtotals & Totals in an Excel Spreadsheet
Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use and Privacy Policy. en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License.
