Excel - COLUMN Function Problem - Expert Solution

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

Sum of Column F2 G2 H2 I2 divided by J2 = %
Solved by X. J. in 17 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 21/09/2018 - 06:49
Hi, Welcome to Excel Chat
User 21/09/2018 - 06:49
Hi
Excelchat Expert 21/09/2018 - 06:50
You want to know the Sum of Column F2 G2 H2 I2 divided by J2 in %?
User 21/09/2018 - 06:50
Yes
Excelchat Expert 21/09/2018 - 06:50
Before we get started, this is a reminder that our policy is 1 problem per session with additional Q&A on that problem as time allows.
User 21/09/2018 - 06:50
Thanks
Excelchat Expert 21/09/2018 - 06:50
I am going to write the formula.
Excelchat Expert 21/09/2018 - 06:51
=sum(F2:I2)/J2
Excelchat Expert 21/09/2018 - 06:51
Apply the formula in the respective cell.
Excelchat Expert 21/09/2018 - 06:51
The change the format of the cell to %.
Excelchat Expert 21/09/2018 - 06:54
Please refer the example provided in the preview.
Excelchat Expert 21/09/2018 - 06:54
I have entered few numbers from F to J in row 2.
Excelchat Expert 21/09/2018 - 06:55
And calculated the value in A1 cell. I have applied the % format to that.
User 21/09/2018 - 06:56
How would I apply to multiple rows? If there are numbers in multiple rows.
Excelchat Expert 21/09/2018 - 06:57
Can you please make use of the preview to show the arrangment?
Excelchat Expert 21/09/2018 - 06:57
I tried to write an example for it.
Excelchat Expert 21/09/2018 - 06:58
Please refer row 3. Where i have copied the formula cell in L2 to L3.
Excelchat Expert 21/09/2018 - 06:58
You can simply drag down the formula to apply both formulas and formats.
User 21/09/2018 - 07:00
Can you show me how you drag the formula
Excelchat Expert 21/09/2018 - 07:00
Select the cell.
Excelchat Expert 21/09/2018 - 07:00
You can see a rectangular border around it.
Excelchat Expert 21/09/2018 - 07:00
Please observe at right bottom corner, there is a dot.
Excelchat Expert 21/09/2018 - 07:01
Hover on the dot, your cursor will change. Hold on it and drag down.
Excelchat Expert 21/09/2018 - 07:01
It copies the formula along with format.
Excelchat Expert 21/09/2018 - 07:03
Hi, there?
Excelchat Expert 21/09/2018 - 07:03
Hope, you have tried it?
User 21/09/2018 - 07:04
I did try but nothing is populating in the cells
Excelchat Expert 21/09/2018 - 07:04
Can you please try in the preview.
Excelchat Expert 21/09/2018 - 07:04
Select L3 cell.
Excelchat Expert 21/09/2018 - 07:05
Please select L3 cell.
Excelchat Expert 21/09/2018 - 07:05
And hover your cursor on Right bottom corner of the cell.
Excelchat Expert 21/09/2018 - 07:05
Can you see a dot?
User 21/09/2018 - 07:05
yes
Excelchat Expert 21/09/2018 - 07:06
When you hover on it, are you able to see that your cursor is changed to plus symbol?
Excelchat Expert 21/09/2018 - 07:06
Ok. You did it now.
User 21/09/2018 - 07:06
Got it! Thanks so much!
Excelchat Expert 21/09/2018 - 07:06
You can further drag down till the extend you need
Excelchat Expert 21/09/2018 - 07:06
Great to hear.
Excelchat Expert 21/09/2018 - 07:06
Thanks for coming to Excelchat. Please leave a great feedback. Have a nice day.
User 21/09/2018 - 07:07
Thanks again, hope you have a great day too.

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
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc