Hi,
In cell N2 I have a simple formula to count the total number of rows in a
given range that are populated, here it is

COUNTA(B8:B100)

problem is I enter the formula either directly into the cell or into the
formula bar , as soon I hit the enter key the answer is given, but the
formula disappears
any ideas
thanks