subtotal with multiple arguments

[lezawang]

Hi
I know how to use subtotal with 2 arguments, the function code and reference. I just found out that subtotal takes more than one references as argument. I search and could not find any good tutorial explain when multiple references are used. Also why we have 2 codes for sum for example 9 and 109?

The following tutorial just saying subtotal takes multiple references, without an example and why? Thanks for you help.

Additional ref Arguments
We can also add additional ranges to the formula. We can include additional columns that are not contiguous (next to each other), by adding additional ref ranges to the formula. These range references are separated by a comma. We can add up to 254 additional range references.

The Excel SUBTOTAL Function - Calculations on Filtered & Visible Cells Only

Learn how the SUBTOTAL function works in Excel to create formulas that calculate results on the visible cells of a filtered range or exclude hidden rows.

www.excelcampus.com

 

[RoryA]

You'd use multiple ranges for the same reason you would in any function, such as SUM.

The reason for both 9 and 109 is that one ignores rows that are manually hidden as well as filtered rows, the other doesn't.

 

[lezawang]

Simple explanation but makes big big difference. Thank you so much. it is clear now.