I need to total a spreadsheet column. How do I do this with the easy
calculator? I have tried several different ways to total the column with the
easy calculator but apparently I am doing something wrong as I don't get a
total. Would appreciate help on this. Thank you!
--
Barbara

Say you want to sum the values in A1 to A100. Put the following formula in
A101...

=SUM(A1:A100)


"Barbara" wrote in message
...
I need to total a spreadsheet column. How do I do this with the easy
calculator? I have tried several different ways to total the column with
the
easy calculator but apparently I am doing something wrong as I don't get a
total. Would appreciate help on this. Thank you!
--
Barbara

You press the Easy button.
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware
(Excel Add-ins / Excel Programming)



"Barbara"
wrote in message
I need to total a spreadsheet column. How do I do this with the easy
calculator? I have tried several different ways to total the column with the
easy calculator but apparently I am doing something wrong as I don't get a
total. Would appreciate help on this. Thank you!
--
Barbara

I don't think that "Easy calculator" is a term that Microsoft use in the
context of Excel. What do you mean by the term?
If you want to total a column, you can use =SUM(A:A)

If you mean the functions that can occur in the status bar at the bottom of
the Excel window, then providing you've got "Status bar" selected under the
"View" menu, you can select a range and then the Status bar will show you
whatever function is selected. Right-click in the status bar to change it
from Count or Average or whatever to Sum.
--
David Biddulph

"Barbara" wrote in message
...
I need to total a spreadsheet column. How do I do this with the easy
calculator? I have tried several different ways to total the column with
the
easy calculator but apparently I am doing something wrong as I don't get a
total. Would appreciate help on this. Thank you!
--
Barbara

To: Gaurav, Jim and David

First of all I owe all of you an apology. The spreadsheet was a Microsoft
Spreadsheet and not an Excel. Next, I want to thank you all for the quick
response to my question. From Gaurav's response, I was able to calcuate the
totals of the columns. Again thank all of you.
--
Barbara


"Barbara" wrote:

I need to total a spreadsheet column. How do I do this with the easy
calculator? I have tried several different ways to total the column with the
easy calculator but apparently I am doing something wrong as I don't get a
total. Would appreciate help on this. Thank you!
--
Barbara

You've confused us again. What do you mean by "a Microsoft Spreadsheet" if
not Excel? Do you mean "Microsoft Works"?
--
David Biddulph

"Barbara" wrote in message
...
To: Gaurav, Jim and David

First of all I owe all of you an apology. The spreadsheet was a Microsoft
Spreadsheet and not an Excel. Next, I want to thank you all for the quick
response to my question. From Gaurav's response, I was able to calcuate
the
totals of the columns. Again thank all of you.
--
Barbara


"Barbara" wrote:

I need to total a spreadsheet column. How do I do this with the easy
calculator? I have tried several different ways to total the column with
the
easy calculator but apparently I am doing something wrong as I don't get
a
total. Would appreciate help on this. Thank you!
--
Barbara

I am sorry and do apologize! It is spreadsheet from Microsoft Works! Please
understand that I am a beginner with using this type of program on the
computer.
--
Barbara


"David Biddulph" wrote:

You've confused us again. What do you mean by "a Microsoft Spreadsheet" if
not Excel? Do you mean "Microsoft Works"?
--
David Biddulph

"Barbara" wrote in message
...
To: Gaurav, Jim and David

First of all I owe all of you an apology. The spreadsheet was a Microsoft
Spreadsheet and not an Excel. Next, I want to thank you all for the quick
response to my question. From Gaurav's response, I was able to calcuate
the
totals of the columns. Again thank all of you.
--
Barbara


"Barbara" wrote:

I need to total a spreadsheet column. How do I do this with the easy
calculator? I have tried several different ways to total the column with
the
easy calculator but apparently I am doing something wrong as I don't get
a
total. Would appreciate help on this. Thank you!
--
Barbara