subtotal() question

[lezawang]

Hi
let say I have A1:A10 column. Lets say I did filter to that column. My question, which range I should use in my subtotal function. The one before the filter (A1:A10) or after the filter?

Also I just noticed that subtotal can take more than 2 arguments! function #, ref1, ref2 etc what ref2 is used for?
Thank you so much.

 

[Aladin Akyurek]

What is the objective?

 

[Eric W]

Use the range address before filtering, A1:A10. Depending on what function code you use, SUBTOTAL will return the answer for all the cells in the ranges, or just the non-hidden cells.

The second (or more) range is if you have additional ranges to include.

=SUBTOTAL(103,A1:A10,C1:C10)

That will sum the non-filtered cells in both ranges.

 

[lezawang]

Thanks a lot all. It is clear now. The objective to learn excel. I am trying different scenarios etc. Thanks again