I have a subtotal formula which works fine. I can copy it from one column to another and it still works properly. But if I directly edit it in any way -- change the text prefixed, change the range by direct edit or expanding the box -- it stops working by becoming text only. If I use Replace to change the prefix text or range, it continues to work correctly.
Auto-calc is on; F9 does no different. Using Excel 2007, activated, format as general or text, xlsx or xlsm -- no difference.
Welcome to the forum.
It must be specific to your version - I cannot replicate the issue in MS365.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Seem no problem with the formula. Could you give more detail, which cell, edit what, before and after result.
Quang PT
A1 is formatted as Text so will behave the way you describe. If you are copying that to other cells, they will also behave that way unless you alter the cell format to General and then re-enter the formula.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks