Total the data in an Excel table - Microsoft Support
You can quickly total data in an Excel table by enabling the Total Row option, and then use one of several functions that are provided in a drop-down list for each table column. The Total Row default selections use the SUBTOTAL function, which allow you to include or ignore hidden table rows, however you can also use other functions.
Sum values based on multiple conditions - Microsoft Support
If you want to create a total value for just one range based on a value in another range, use the SUMIF function.
Calculate a running total in Excel - Microsoft Support
Calculate a running total in Excel. You can use a running total to watch the values of items in cells add up as you enter new items and values over time. To calculate a running total, use the following procedure. Set up a worksheet like the following example.
Look up values with VLOOKUP, INDEX, or MATCH - Microsoft …
It's actually quite easy to do with a lookup function. The VLOOKUP and HLOOKUP functions, together with INDEX and MATCH, are some of the most useful functions in Excel. Note: The Lookup Wizard feature is no longer available in Excel. Here's an example of how to use VLOOKUP. =VLOOKUP (B2,C2:E7,3,TRUE)
Add a Total row to a table - Microsoft Support
You can add totals to a table by selecting the Total Row checkbox on the Design tab. You can also add a function from the total row drop-down. Select a cell in a table. Select Design > Total Row. The Total row is added to the bottom of the table.
Use Excel as your calculator - Microsoft Support
Instead of using a calculator, use Microsoft Excel to do the math! You can enter simple formulas to add, divide, multiply, and subtract two or more numeric values. Or use the AutoSum feature to quickly total a series of values without entering them manually in a formula.
Create a 3-D reference to the same cell range on multiple …
A 3-D reference is useful and convenient way to reference several worksheets that follow the same pattern and cells on each worksheet contain the same type of data, such as when you consolidate budget data from different departments in your organization.
SUMIF function - Microsoft Support
You use the SUMIF function to sum the values in a range that meet criteria that you specify. For example, suppose that in a column that contains numbers, you want to sum only the values that are larger than 5. You can use the following formula: =SUMIF (B2:B25,">5") This video is part of a training course called Add numbers in Excel. Tips:
SUMIFS function - Microsoft Support
The SUMIFS function, one of the math and trig functions, adds all of its arguments that meet multiple criteria. For example, you would use SUMIFS to sum the number of retailers in the country who (1) reside in a single zip code and (2) whose profits exceed a specific dollar value.
Ways to count values in a worksheet - Microsoft Support
You can count the number of values in a range or table by using a simple formula, clicking a button, or by using a worksheet function. Excel can also display the count of the number of selected cells on the Excel status bar.
Replace a formula with its result - Microsoft Support
You can convert the contents of a cell that contains a formula so that the calculated value replaces the formula. If you want to freeze only part of a formula, you can replace only the part you don't want to recalculate.