Excel Trick: Average/Formula for visible range only TLDR; SUBTOTAL(10x,

Today I have learned this trick in Microsoft Excel:

How to calculate an average for a range but for only the visible cells? (e.g. if you hide some rows or use a filter in a Table.)

Short answer:

Use the formula =SUBTOTAL(101,Rng)

Here the link to this great SUBTOTAL function documentation: https://support.microsoft.com/en-us/office/subtotal-function-7b027003-f060-4ade-9040-e478765b9939

(I got this from here https://www.contextures.com/excelaveragefunctions.html. This is the TLDR;)

This post https://excelribbon.tips.net/T013262_Averaging_without_Hidden_Cells.html shows a solution based on a custom function.

I think it was before Excel offering this 10x options in SUBTOTAL