Is this happening in any other cell?
do you have any macros?
"Anthony" wrote:
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
|