Excel's Total Row uses smart SUBTOTAL logic to ignore hidden data, adapt to filters, flag text errors, and measure performance volatility.

Ellen Galinsky is president of the research nonprofit Families and Work Institute in Palisades, N.Y., served as co-lead of ...