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.