You can use SUBTOTAL with special type codes so that values in hidden rows are neglected. For eg. SUBTOTAL(9,A1:A10) finds the sum of values in ...
確定! 回上一頁