1. Computing
Send to a Friend via Email

Using Named Ranges in Excel Formulas

A name can be given to a range of data to make it easier to identify this cell or cells when creating formulas or charts.

More on Formulas in Excel
Spreadsheets Spotlight10

Excel SUM OFFSET Formula

Saturday April 19, 2014
By combining the SUM function with the OFFSET function we can create a lookup formula that uses a dynamic range to incorporate new data as it is added to the worksheet.

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

Thursday April 17, 2014

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

Tuesday April 15, 2014
Count Cells with SUMPRODUCT
Count Cells with SUMPRODUCT
Ted French

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

Saturday April 12, 2014

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

©2014 About.com. All rights reserved.