Forum Discussion
Apply subtotal to formatted structure
Hi, I just realized that function subtotal's "including hidden values" index has no effect to a table (i.e. formatted structure). Say I have a table MyTable with two columns [Type] and [Value], Subto...
9 - exclude subtotals and rows hidden by filter.
109 - exclude subtotals, rows hidden by filter, and rows hidden manually.
With filter turned on, I don't think you will notice a difference between the two. If you turn the filter off completely and then manually hide rows, you should see the difference.
109 - exclude subtotals, rows hidden by filter, and rows hidden manually.
With filter turned on, I don't think you will notice a difference between the two. If you turn the filter off completely and then manually hide rows, you should see the difference.
JMB17 Yes, I think you're right. I tried a few times with table and non-table data and found virtually the difference of subtotal(10X,??) and subtotal(X,??) is nonresistant for the built-in header filter - both excluding hidden cells. The difference of the two only exists when the rows are manually hidden i.e. select the rows, right clicking and hide. Thanks for the advice.
