Following the Gemini automation announcement today, Google is detailing how all this works under the hood on Android.
Excel's Total Row uses smart SUBTOTAL logic to ignore hidden data, adapt to filters, flag text errors, and measure performance volatility.