I am trying to count Os and Xs from a calibration. I have a spreadsheet that we have been using for years with the included formulas in the provided Snip-it. However, I noticed that not all of them were formulas. I think someone entered in a number instead of letting it calculate (must have been unlocked). When I tried to drag the formula to the adjacent cell, it pops up breifly and then reverts directly back to a number (I have selected that my formulas be shown) and of course the number is not even correct. Even if I type out the formula by hand, it reverts back to the number you see in the cell outlined in green. My cells are all set to General not Text.
I am at a loss. Any one have an idea as to what is happening?
Thanks,
Dan
I am at a loss. Any one have an idea as to what is happening?
Thanks,
Dan