lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
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.
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