Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

Have a column of figures say in column F and need total Line 3 thru 60. what is the formula? Also need to know formula for Column for say f+g=h
Solved by M. L. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 14/06/2018 - 12:34
Hello, how are you?
Excelchat Expert 14/06/2018 - 12:36
Hi are you there?
User 14/06/2018 - 12:36
I am retired 80 just trying to learn formulas used years ago but trying to relearn.
Excelchat Expert 14/06/2018 - 12:38
Oh, no worries, First am happy for your age and may you live many more years.
User 14/06/2018 - 12:38
Not very good at typing just bear with me not compuer literate either
Excelchat Expert 14/06/2018 - 12:40
To your first query about totaling, You need to go to the cell where you need the totals to show and type =sum(
Excelchat Expert 14/06/2018 - 12:41
Then select all the cells that you want to sum, close the bracket with ) then press the enter key
Excelchat Expert 14/06/2018 - 12:41
Is that clear enough?
User 14/06/2018 - 12:42
I was a account and used to paper columnar pads pencil and adding machine
Excelchat Expert 14/06/2018 - 12:43
Can you see what am writing on the excel sheet on the right of the chat box?
Excelchat Expert 14/06/2018 - 12:44
Excelchat Expert 14/06/2018 - 12:45
Hi, are you there?
User 14/06/2018 - 12:47
is that done in the box you want the Total below the last entry
User 14/06/2018 - 12:47
After draging
Excelchat Expert 14/06/2018 - 12:49
Yes, any cell that you want the totals to show
User 14/06/2018 - 12:50
Got it how do you get the $ sign on left of column and numbers on right
Excelchat Expert 14/06/2018 - 12:51
Pressing Shift+4
Excelchat Expert 14/06/2018 - 12:54
are you able to do that?
User 14/06/2018 - 12:56
Yes =How do you ad column c=a+b
Excelchat Expert 14/06/2018 - 12:58
you go to c, write =, then click the cells you want to add in column a and b, then press enter
Excelchat Expert 14/06/2018 - 12:59
can you see that, i have written it on the excel sheet.
User 14/06/2018 - 01:07
Do not see it
Excelchat Expert 14/06/2018 - 01:08
and now?
User 14/06/2018 - 01:10
I do not know where to look
Excelchat Expert 14/06/2018 - 01:10
the excel sheet on the right of the chat box
User 14/06/2018 - 01:12
I am looking but I do not see it do it on line 12
Excelchat Expert 14/06/2018 - 01:14
It's there now
User 14/06/2018 - 01:17
It did not add in 12 and 13
Excelchat Expert 14/06/2018 - 01:18
Can you see it now?
User 14/06/2018 - 01:20
Did you put the formula in 12 and drag it to 13
Excelchat Expert 14/06/2018 - 01:20
Yes that's it
User 14/06/2018 - 01:26
I tried to drag 12 to 14 and it did not add
User 14/06/2018 - 01:27
What did you do
Excelchat Expert 14/06/2018 - 01:29
To drag you need to put the cursor at the bottom right corner where there is a blue dot, your cursor will turn to a cross(+) then left click and drag
User 14/06/2018 - 01:34
Do you always put formula up at fx

This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user information.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc