subtotal with multiple arguments

lezawang

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

Excel SUBTOTAL Function Additional Ref Ranges

 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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.
 
Upvote 0
Simple explanation but makes big big difference. Thank you so much. it is clear now.
 
Upvote 0

Forum statistics

Threads
1,223,366
Messages
6,171,659
Members
452,416
Latest member
johnog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top