AVERAGE Pay Per Week in Microsoft Excel
The main purpose of this formula is to calculate average pay per week, excluding weeks where no hours were logged and without total pay per week already calculated.
Here we will learn how to get the average pay per week in the workbook in Microsoft Excel. That implies, with the help of a formula based on the SUMPRODUCT function, you can able to get the calculated average pay per week, excluding weeks where no hours were logged and without total pay per week already calculated.
So, with the help of this formula, you can able to get the average pay per week in the workbook in Microsoft Excel.
General Formula to AVERAGE Pay Per Week
=SUMPRODUCT(hours*rate)/COUNTIF(hours,”>0″)
The Explanation for the AVERAGE Pay Per Week
So we know that with the help of the given formula above, you can able to calculate average pay per week, excluding weeks where no hours were logged and without total pay per week already calculated. Here we will learn how to get the average pay per week in the workbook in Microsoft Excel.
As we know that, function like AVERAGEIF or AVERAGEIFS seems an obvious solution. However, because total pay per week is not part of the worksheet, we can’t use these functions because they require a range.
So, with the help of this formula, you can able to get the average pay per week in the workbook in Microsoft Excel.