uk_dave&gill
Board Regular
- Joined
- May 17, 2007
- Messages
- 79
I seem to be having strange things going on with Excel at present. First it was formulas that didn't appear anywhere (even in the formula bar) until they had done their calculations, now I've got a new one....
I just entered a fairly simply formula
=COUNTIF(U9:U500,"a")
which worked well and gave the result of 138, as expected. But then I clicked into the cell I'd just entered the formula in, and, instead of showing the formula, it showed "138"...
So, somehow it's working as a "once only" calculation?
Can anyone help?
I just entered a fairly simply formula
=COUNTIF(U9:U500,"a")
which worked well and gave the result of 138, as expected. But then I clicked into the cell I'd just entered the formula in, and, instead of showing the formula, it showed "138"...
So, somehow it's working as a "once only" calculation?
Can anyone help?