When first argument in the SUBTOTAL function is in the range 101-111,only the visible values in the specified range are used.

Question

Quizplus · Accepted Answer

When the first argument in the SUBTOTAL function is in the range 101-111, only the visible values in the specified range are used for the calculation. This is because these arguments correspond to specific functions that are designed to work with visible cells only.

When First Argument in the SUBTOTAL Function Is in the Range