I used to operate Excel 2016 reasonably competently but TRIPLE BYPASS OPERATION HAS IMPAIRE ME

%3CLINGO-SUB%20id%3D%22lingo-sub-2204726%22%20slang%3D%22en-US%22%3EI%20used%20to%20operate%20Excel%202016%20reasonably%20competently%20but%20TRIPLE%20BYPASS%20OPERATION%20HAS%20IMPAIRE%20ME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2204726%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20achieve%20the%20simplest%20task%2C%20getting%20a%20total%20for%20figures%20from%20f13%20to%20f27%2C%20the%20formula%20in%20the%20fortmula%20bar%20is%26nbsp%3B%3DSUM(F13%3AF27)%20but%20it%20doesn't%20work%20no%20total%20appears%20in%20th%20chosen%20cell%2C%20I%20have%20formatted%20the%20column%20as%26nbsp%3B%20currency%20with%20two%20decimal%20places%2C%20please%2C%20what%20am%20i%20doing%20wrong.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2204726%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2204828%22%20slang%3D%22en-US%22%3ERe%3A%20I%20used%20to%20operate%20Excel%202016%20reasonably%20competently%20but%20TRIPLE%20BYPASS%20OPERATION%20HAS%20IMPAIRE%20ME%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2204828%22%20slang%3D%22en-US%22%3EAs%20you%20describe%20the%20situation%2C%20you%20have%20done%20nothing%20wrong.%3CBR%20%2F%3EAre%20you%20sure%20F13%3AF27%20actually%20contains%20numbers%2C%20not%20text%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%20your%20recovery%20(body%20and%20mind)%20goes%20well.%3C%2FLINGO-BODY%3E
New Contributor

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 formatted the column as  currency with two decimal places, please, what am i doing wrong.

3 Replies
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.

@Peter Bartholomew  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......

@Jatobel01 

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.

image.png