How to total a column of cells without using Autosum
in [General]
|
Prev: Spreadsheet filename no longer appears in title bar
Next: Totaling cells from separate worksheets to master form
From: Goldar on 21 Apr 2010 16:56 Help me remember please. I used to be able to quickly total a rance of cells by simply highlighting them. The total would then appear in the fx box. I can't seem to remember how do do this. I'm using Excell in Office 2003. Thanks
From: Mike H on 21 Apr 2010 17:17 Hi, Select a cell directly under or to the side of the range and click the auto-sum button (sigma) button -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Goldar" wrote: > Help me remember please. I used to be able to quickly total a rance of cells > by simply highlighting them. The total would then appear in the fx box. I > can't seem to remember how do do this. I'm using Excell in Office 2003. > > Thanks
From: Bob I on 21 Apr 2010 17:19 Look below on the Status bar instead for the Sum. Goldar wrote: > Help me remember please. I used to be able to quickly total a rance of cells > by simply highlighting them. The total would then appear in the fx box. I > can't seem to remember how do do this. I'm using Excell in Office 2003. > > Thanks
From: Jim Thomlinson on 21 Apr 2010 17:46
In the bottom right hand corner of XL (on the status bar) you will see NUM if you have number lock turned on. 2 boxes to the left of that is the area where you are thinking of. Right click on that box an dyou will get a list of choices incuding Sum, Count, Max, ... If you have an error such as #N/A or Div by zero in the highlighted area then the totaling will not work. -- HTH... Jim Thomlinson "Goldar" wrote: > Help me remember please. I used to be able to quickly total a rance of cells > by simply highlighting them. The total would then appear in the fx box. I > can't seem to remember how do do this. I'm using Excell in Office 2003. > > Thanks |