If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to total a column of cells without using Autosum
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 |
#2
|
|||
|
|||
How to total a column of cells without using Autosum
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 |
#3
|
|||
|
|||
How to total a column of cells without using Autosum
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 |
#4
|
|||
|
|||
How to total a column of cells without using Autosum
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 |
Thread Tools | |
Display Modes | |
|
|