AVERAGEIF and AVERAGEIFS functions in Excel used to calculate the average in a range of cells. Learn how to use AVERAGEIF and AVERAGEIFS.

Averaging values in an Excel sheet is easy. But perhaps you want to ignore zeros or include multiple sheets. Knowing how each averaging function works is the key to choosing the right one.

How to Calculate the Average Annual Rate of Return in Excel. If your business makes investments in equipment and employee benefit contributions, you may need to track the average annual rate of ...

This is the demonstration file to accompany the article, How to average unique values in Excel the easy way, by Susan Harkins.

How to Use Microsoft Excel to Calculate Seasonal Indexes. A seasonal index is a way of measuring the seasonal variation -- that is, to measure the change that is due to seasonal changes in demand ...

Find out more about the price-to-earnings, or P/E, ratio, the P/E ratio formula and how to calculate the P/E ratio in Microsoft Excel.