이 함수는 Google Sheets에서도 Excel과 동일하게 작동합니다 — 구문과 인수가 같습니다.
SUBTOTAL(function_num, ref1, …)The SUBTOTAL function is unique because it can ignore hidden rows and nested subtotals. It uses a function number to determine which calculation to perform, such as SUM, AVERAGE, or COUNT.
=SUBTOTAL(9, A1:A10)결과: 500
Calculates the sum of cells A1 through A10, ignoring any other subtotals within that range.
9 includes hidden rows in the calculation, while 109 ignores rows that are manually hidden.