allows you to calculate the sum of selected values without duplicating values in the grand total.

The SUBTOTAL function calculates a summary, such as a sum, while excluding other SUBTOTAL results in the range. This helps prevent values from being counted twice when a grand total includes smaller subtotals. The correct choice is “The subtotal function.”

AI-written and checked against the verified answer.