00:00Someone asked me a while back ago in a subtotal function, what's the difference
00:03between this 9 and the 109? So here it is. So if you want to do a calculation or
00:09subtotal of a filter, you use 9. Let me show you. If I want to do only stage 2,
00:14you see how the 9 get affected. But if you want to do a calculation of a hidden
00:19row like that, press ctrl 9 to hide row, you use the function name 109. So in
00:26short, if you want to do a subtotal of filtered values, you use function code 9.
00:30And if you want to do a subtotal of a hidden row or filter, you use function name
00:36109. So another thing I want to note down is that we baseline that if you do
00:40filtering like this, like for example, you know, the function name 9 get affected.
00:45But if you hide filter and also hide at the same time, you see how this is affected
00:50here as well, the number 9. So just to be aware of, I think this is a bug in Excel.
Comments