**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.*