Learn how to calculate Weighted Average in Excel with percentages using the SUM function and the SUMPRODUCT function.

How to Calculate Weighted Average Using Excel To calculate this weighted average, first input the two values for the number of shares outstanding into adjacent cells.

Learn the criteria expression for finding blank cells using Excel's Advanced Filter feature. A few weeks ago, I showed you how to use And and Or operators with Excel’s Advanced Filter feature.

Calculate the weighted average of interest rates in Microsoft Excel to compute the most accurate average interest rate among a group of lenders who received different rates.

There are two ways to calculate a conditional average in Excel, both involve some logic and some special functions.

Sometimes you just want to tell Excel what it is you want your formula to do. It'd be a lot easier if you could just say "sort this data in ascending order and find its average" i ...

Topline Spreadsheets aren’t just for business owners and data analysts—here are some easy ways to integrate Microsoft Excel into your life.