How to total a column of cells without using Autosum

  • Thread starter Thread starter Goldar
  • Start date Start date
G

Goldar

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
 
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.
 
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.
 
Back
Top