I have excell row containing 100 cells. First 20 rows have numbers then 50 cells are 0 again last 30 cells have numbers. In 101th cell have also number. (Lets assume that 101th cell have 25)
I want avarage of 25 cells beginning from the 100th cell to back. I need formula for this situation.
The normally SUM/Count/Average function will count all cells in the specified range on matter cells are hidden/filtered or not. While the Subtotal function can only sum/count/average with ignoring hidden rows. However, Kutools for Excel SUMVISIBLE/COUNTVISIBLE/AVERAGEVISIBLE functions will easily calculate the specified range with ignoring any hidden cells, rows, or columns. For more info you can use this best essay service to having a wonderful assistant in writing tasks.
The AVERAGE function will average cells that contain numbers. Its syntax is:
The arguments (e.g. value1) can be cell references, or values typed into the AVERAGE formula.