When using the SUBTOTAL function,entering a number from 1 to 10 in the SUBTOTAL function's first argument will result in the filtered only data being used.

Question

Quizplus · Accepted Answer

Entering a number from 1 to 11 in the SUBTOTAL function's first argument includes both hidden and visible rows in the calculation, whereas numbers from 101 to 111 exclude hidden rows but include rows hidden by filtering.

When Using the SUBTOTAL Function,entering a Number from 1 to 10