In spreadsheets of MS Excel, sometimes data from more than one category is available and SUBTOTAL function helps in getting the totals of various columns of data of different categories.

SUBTOTAL = (method, range1, [ange2..range_n])

BY Best Interview Question ON 01 Apr 2019