Forum Discussion
Jatobel01
Mar 12, 2021Copper Contributor
I used to operate Excel 2016 reasonably competently but TRIPLE BYPASS OPERATION HAS IMPAIRE ME
I am trying to achieve the simplest task, getting a total for figures from f13 to f27, the formula in the fortmula bar is =SUM(F13:F27) but it doesn't work no total appears in th chosen cell, I have ...
PeterBartholomew1
Mar 12, 2021Silver Contributor
As you describe the situation, you have done nothing wrong.
Are you sure F13:F27 actually contains numbers, not text?
I hope your recovery (body and mind) goes well.
Are you sure F13:F27 actually contains numbers, not text?
I hope your recovery (body and mind) goes well.
Jatobel01
Mar 15, 2021Copper Contributor
PeterBartholomew1 Thank you so much for your help and your good wishes, if I had known my cognitive ability would be impaired I would not have had the procedure and taken my chances. one other question, how should i format the cells in the column, I am only entering dollar amounts, General, Number, accounting etc......
- PeterBartholomew1Mar 16, 2021Silver Contributor
Just keep active. The effects of anaesthetic wear off over time!
Try currency format. If the currency symbols do not show, you do not have numbers.