I have a list of items (cells A1 to A7) that are counted in cell B2 (whose value is currently 7)  B2's formula is something like =COUNTA(A1:A10000) That way if I add some value in cell A8  the count is updated to 8 in cell B2