SUBTOTAL In Excel
Excel SUBTOTAL function returns the subtotal of the numeric values in a column from a database. Excel SUBTOTAL function is used as part of a formula in a cell of a worksheet for column or row according to your database. Subtotal has several different types of option available with unique code which you can use it with some of them are SUM, COUNT, COUNTA and many more for auto calculate.