In the worksheet shown above, the formulas in C4 and F4 are: =SUBTOTAL(3,B7:B19) // count visible =SUBTOTAL(9,F7:F19) // sum visible ...
確定! 回上一頁