## Excel SUM OFFSET Formula

The SUM function, by itself, will usually accommodate inserted cells of data with one exception - when the data is inserted into the cell where the function is currently located.

By using the SUM and OFFSET functions together, however, the range that is totaled becomes dynamic. Or, in other words, it changes to accommodate new cells of data. The addition of new cells of data does not cause problems because the range continues to adjust as each new cell is added.

To find out all the details, read this tutorial on the Excel SUM OFFSET Formula

**Related Tutorials**

## Sum Cells with SUMPRODUCT

In addition to counting cells that meet multiple conditions set by the user, the SUMPRODUCT function can also sum the contents of those cells.

Even though Excel has the better known SUMIF and SUMIFS functions to add up values that meet one or more conditions, SUMPRODUCT still has its uses.

One such use is summing the data in cells that fall between two values.

For more information, read this short tutorial on how to **Sum Cells between Two Values with SUMPRODUCT**.

**Related Tutorials**

## Counting with SUMPRODUCT

SUMPRODUCT is one of Excel's more unique functions.

For one, it is *undocumented*, which means it does not get listed with other functions, nor does it provide users with the dialog box option for filling in the function's arguments.

Second, in addition to its normal job of adding together the results of multiple multiplication operations, it can also be used to count up the number of cells in a range that meet specific criteria.

To find out more, read this short tutorial on how to **Count Cells between Two Values with SUMPRODUCT**.

**Related Tutorials**

## Excel RADIANS Function

Excel has a number of functions that can help you carry out basic trigonometry operations such as finding the tangent or cosine of an angle.

The only problem is that these functions require that angles be measured in radians.

Since most of us measures angles in degrees, Excel has a function that converts these degree measurements to radians.

In doing so, Excel makes using its trig functions as is easy as Pi.

To find out all the details on using this handy function, read the tutorial on the **Excel RADIANS Function**.

**Related Tutorials**

## Excel COS Function

Another of Excel's trigonometric functions includes the *COS* function which is used to find the cosine of an angle.

Trigonometry has application in a number of fields including astronomy, physics, engineering, and surveying.

In particular, the uses for the cosine of an angle include modeling such things as sound and light waves.

To find out all the details of using this function, read this tutorial on the**Excel COS Function**.

**Related Articles**

## Find the Sine of an Angle in Excel

Trigonometry has application in a number of fields including astronomy, physics, engineering, and surveying.

One of the trigonometric functions in Excel is the SIN function which gives you the sine of an angle measured in radians.

To find out all the details on how this is done, read this tutorial on the

**Excel SIN Function**.

**Related Tutorials**

## Calculate Weighted Average in Excel

The AVERAGE Function is handy to know and one that I, as a teacher, use frequently.

However, when it comes to student marks, rather than finding the average I often want to find a *weighted* average.

As the name suggests, a weighted average places more weight or value on certain elements - such as exams - than on other elements being averaged.

In addition to marking, the weighted average can be used anywhere where you need to find the average for data of unequal value.

To find out all the details, read this short tutorial on **Calculating the Weighted Average in Excel**.

**Related Tutorials**

## Ignore Zeros when Finding the Average

While the AVERAGE Function is very useful when it comes to finding the arithmetic mean for a range of data, it does have limitations.

For example, if you want to exclude certain data from the data that throws off the average - such as zero values - the AVERAGE function can't do it.

Fortunately, Excel has another function that can handle specific situations such as ignoring zero values when finding the average - it's called *AVERAGEIF*.

By allowing the user to set conditions on what data gets averaged, this function can easily accommodate this type of situation.

To find out all the details, read this short tutorial on **Ignore Zeros when Finding the Average**.

**Related Tutorials**

## Excel INDEX Function

The INDEX function uses row and column numbers from an array to return the name of a specific item of data in an Excel database or table of data.

INDEX is often combined with other lookup functions, such as the MATCH function, to create versatile lookup formulas.

To find out all the details on how this function works, read this short tutorial on the **Excel INDEX Function**.

**Related Tutorials**

## Excel Left Lookup Formula

Although VLOOKUP is one of Excel's most used functions, on its own it is limited to looking to the right of the lookup criterion when trying to find information in a database.

By combining it with the CHOOSE function, however, we can create what is known as a *left lookup* formula that allows us to find fields of information to the left of the lookup value.

Advantages of a left lookup formula include:

- it permits the lookup value to be chosen from any column in the data table
- return information located in any column to the left of the lookup value

To find out all the details, read the tutorial on the **Excel Left Lookup Formula**.

**Related Tutorials**