- Picture and text skills
- Case
Returns a list of data or a subtotal in the database. Generally, you can easily create a subtotal with subtotals using the Subtotals command on the Data menu
General data list. Once a subtotal is created, the data list can be modified by editing the SUBTOTAL function.
Syntax
SUBTOTAL (function_num,ref1,ref2,...)
■Function_num is a number between 1 and 11 (including hidden values) or 101 and 111 (ignoring hidden values), specifying which function to use In dataclear
Perform classification and summary calculations in single items.
■Ref1, ref2, are 1 to 29 ranges or references to be calculated for subtotals.
Description
■If there are other subtotals (nested subtotals) in ref1, ref2,…, these nested subtotals will be ignored to avoid double counting .
■When function_num is from 1 to 11 constant, the SUBTOTAL function will include Hide under the Row" submenu of the Format menu.
The value in the row hidden by the command. Use these constants when you want to subtotal hidden and non-hidden values in a list. When function_num is from 101
To a constant of 111, the SUBTOTAL function ignores values in rows hidden by theHide command under the Rows submenu of the Format menu .
Use these constants when you only subtotal non-hidden numbers in a list.
■SUBTOTAL The function ignores any rows that are not included in the filtered results, regardless of the function_num value used.
■SUBTOTAL function is suitable for data columns or vertical area. Does not apply to data rows or horizontal areas.
For example, when function_num is greater than or equal to 101 and a horizontal area needs to be classified and summarized,
For example, SUBTOTAL(109,B2:G2), hiding a column will not affect the subtotal.
But hiding a row in the vertical area of the subtotal will affect it.
■If a specified reference is a three-dimensional reference, the SUBTOTAL function returns the #VALUE! error value.
Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/shu-xue-he-san-jiao-han-shu-SUBTOTAL-han-shu-ji-suan-bao-han-huo-hu-lyue-yin-cang-de-shu-zhi.html
评论列表(196条)
测试