Text: How to use the Excel TEXT function to Convert a number to text in a number format. Excel Formulas A collection of useful Excel formulas for sums and counts, dates and times, text manipularion, conditional formatting, percentages, lookups, and more! Jul 18, 2018 · In this article, I will show you how to calculate the weighted average in Excel with percentages. The weighted average is the average where some numbers are taken into consideration as the weighted elements for finding the average. It is different from the normal average as the weighted elements contribute to the final result more heavily than the other elements. Here I will calculate the weighted average with percentages. The AVERAGE function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the AVERAGE function can be entered as part of a formula in a cell of a worksheet. Excel inserts this formula automatically when you select Average from the drop-down list. Using SUBTOTAL in the Total Row means that when the Table is Filtered, the function will give the correct answer. If you toggle the Total Row off, Excel remembers the function and it will appear again when you toggle the Total Row back on.