What is the use of subtotal function in Excel?
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