When I filter a column, and then use the sum function to sum up the total for that column, it is giving me the total including all the hidden rows, what is the proper way to do it, that the row numbers should show 1,2,3,4 instead of their original ones that causes the problems.
(I saw online that I can use subtotal,9 but is that the only way?)
Somehow I don't have this problem with all files