And =subtotal(109,B2:B5) will give you sum of all visible values (excluding hidden) between B2 and B5. Using Subtotal Function from Excel Ribbon: You can also ...
確定! 回上一頁