Tuesday April 15, 2014

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**

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**

Wednesday April 9, 2014

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**
Monday April 7, 2014

Excel SIN Function

© Ted French

Excel's list of math

functions includes a number of the most common trigonometric functions.

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**