To sum a total in multiple tables, you can use the SUM function and structured references to refer to the columns to sum. In the example shown, the formula in I6 is:
=SUM(Table1[Amount],Table2[Amount])
How this...

To calculate gas (MPG) based on odometer readings you can build a table with a few simple formulas. In the example shown, the formulas in E5 and F5 are:
=[@Mileage]-SUM(C4) // E5 calculate mileage
=[@Distance]/[@...

To sum every n rows, you can use a formula based on the OFFSET and SUM functions. In the example show, the formula in F4 is:
=SUM(OFFSET($C$3,(ROW()-4)*5,0,5,1))
How this formula works
In this example, there are 5...

This examples shows how to calculate a volunteer hour requirement. The requirement is to have 15 volunteer hours, with at least 5 in each category. The formula in F6 is:
=AND(COUNTIF(C6:E6,">=5")=3,SUM(C6...

To enable a dropdown with an "all" option you can use data validation for the dropdown list, and a formula based on IF, SUM, and SUMIF functions to calculate a conditional sum. In the example shown the formula in G5 is...

To calculated a weighted average, you can use the SUMPRODUCT function together with the SUM function. In the example shown, the formula in G7 is:
=SUMPRODUCT(C5:C11,D5:D11)/SUM(D5:D11)
How this formula works
The...

To calculate a running total, or cumulative sum, you can use the SUM formula with a mixed reference that creates an expanding range. In the example shown, the formula in cell D6 is:
=SUM($C$6:C6)
When this formula is...

To sum all values in a column or row, you can use the INDEX function to retrieve the values, and the SUM function to return the sum. This technique is useful in situations where the row or column being summed is...

To check to see if a cell contains more than one substring, you can use a formula based on the COUNTIF function.
In the example shown, the formula in C5 is:
=IF(SUM(COUNTIF(B5,{"*abc*","*aaa*...

To test values to see if they begin with one of several characters (i.e. begin with x, y, or z) , you can use the COUNTIF function together with the SUM function.
In the example shown, the formula in C5 is:
=SUM(...

If you want to sum an entire column without supplying an upper or lower bound, you can use the SUM function with and the specific range syntax for entire column.
In the example shown, the formula in G6 is:
=SUM(D:D...

To create a running total in an Excel Table, you can use the INDEX function set up with a structured reference. In the example shown, the formula in F5 is:
=SUM(INDEX([Total],1):[@Total])
When copied down the column...

To sum based on multiple criteria using OR logic, you can use the SUMIFS function with an array constant. In the example shown, the formula in H6 is:
=SUM(SUMIFS(E4:E11,D4:D11,{"complete","pending...

To sum the top values in a range, you can use a formula based on the LARGE function, wrapped inside the SUMPRODUCT function. In the generic form of the formula (above), rng represents a range of cells that contain...

To sum the bottom n values in a range matching criteria, you can use an array formula based on the SMALL function, wrapped inside the SUM function. In the generic form of the formula (above), range1 represents the range...