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.

An alternative Excel averaging formula that doesn’t evaluate zero Your email has been sent Excel's AVERAGE() function evaluates zero values. If you want to exclude zeroes, use these alternatives ...

VIDEO: These functions in Excel let you summarize data based on different characteristics.

Excel provides one general formula that finds the difference between numbers, dates and times. It also provides some advanced options to apply custom formats to your results.

How to Plot a Formula in Excel. Unless you are an accountant or a math whiz, the formulas used in financial calculations may seem like random, nonsensical strings of numbers, letters and Greek ...

Learn about the weighted average cost of capital (WACC) formula in Excel and use it to estimate the average cost of raising funds through debt and equity.