Excel SUBTOTAL Function
What is the Excel SUBTOTAL Function? The Excel SUBTOTAL function returns a value from 11 available functions such as SUM, COUNT, AVERAGE, MIN, MAX, etc. (see table below for complete function list) with an option to include or exclude the hidden rows. SUBTOTAL Syntax SUBTOTAL(function_num,ref1,,...) function_num, …