lezawang
Well-known Member
- Joined
- Mar 27, 2016
- Messages
- 1,805
- Office Version
- 2016
- Platform
- Windows
Hi
Let say I have A1:A100 column. I want to find the subtotal. I filtered column A and now I have 20 cells. Should use subtotal before filtering the column? I mean to select A1:A100 or after filtering the column and then select the 20 cells left? I tired it both, sometime both work but some other not. Thank you very much.
Let say I have A1:A100 column. I want to find the subtotal. I filtered column A and now I have 20 cells. Should use subtotal before filtering the column? I mean to select A1:A100 or after filtering the column and then select the 20 cells left? I tired it both, sometime both work but some other not. Thank you very much.
Last edited:
