ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Cant use sum function or status bar (https://www.excelbanter.com/excel-discussion-misc-queries/240434-cant-use-sum-function-status-bar.html)

Medways

Cant use sum function or status bar
 
My auto sum will not work have followed help function and still no joy select
cell below and formula appears click auto sum twice and error message. Tried
to update status bar (right click for menue) none of my selections other than
count show.

Jacob Skaria

Cant use sum function or status bar
 
Check whether the cells are in text format. (Right clickFormatCells). To
convert the cells to numerics do the below.
--Copy a blank cell
--Keeping the copy select the range of cells with numeric values
--Right clickPasteSpecial
--Select 'Add' and click OK and check your status bar

If this post helps click Yes
---------------
Jacob Skaria


"Medways" wrote:

My auto sum will not work have followed help function and still no joy select
cell below and formula appears click auto sum twice and error message. Tried
to update status bar (right click for menue) none of my selections other than
count show.



All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com