What does the SUBTOTAL function do in Excel?

Calculates the total excluding hidden rows

Sums all cells in a range

Averages visible cells only

Counts unique values

SUBTOTAL() calculates a subtotal (e.g., sum, average) while ignoring rows hidden by filters.

Strengthen Your Practice with our comprehensive question bank.

Get Expert Advice for Free: Register for Your Free Consultation Now!

Full Name

Phone Number

Select Language

Select Course

Please leave this field empty.