**Question description:**

*This user has given permission to use the problem statement for this blog.*

in cell A I have a total of 71 in cell B a total of 47. the combined total is 118. I would like to know the formula that will take the sum of cell A and cell B divide this by cell A

Solved by M. W. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
08/06/2018 - 02:54

Hi Welcome to got it pro!

Excelchat Expert
08/06/2018 - 02:55

=sum(A1:B1)/A1

Excelchat Expert
08/06/2018 - 02:55

For your question, here is the answer based on current cell layout

User
08/06/2018 - 02:56

how about in reverse to get the result of 0.601

Excelchat Expert
08/06/2018 - 02:56

Well, not sure what numbers you would like to change in this case

User
08/06/2018 - 02:57

if you divide 71 with 118 you will get 0.601

Excelchat Expert
08/06/2018 - 02:58

you mean 118 / 71?

Excelchat Expert
08/06/2018 - 02:59

The result is in A5

User
08/06/2018 - 03:00

that equal 1.66.... I am looking for the formula for 71/118 that will equal 0.601

User
08/06/2018 - 03:00

between the 2 said cells

Excelchat Expert
08/06/2018 - 03:00

Ok

Excelchat Expert
08/06/2018 - 03:03

Ok

Excelchat Expert
08/06/2018 - 03:03

Now, its kind of reverse the work

Excelchat Expert
08/06/2018 - 03:03

And calculate one of the sums

User
08/06/2018 - 03:10

didn't work

Excelchat Expert
08/06/2018 - 03:10

which one?

User
08/06/2018 - 03:11

=sum(A1:B1)/A1 in reverse

Excelchat Expert
08/06/2018 - 03:12

Well, i believe the answer you are looking for is how the 71/118 came from correct?

Excelchat Expert
08/06/2018 - 03:12

now sum of A2 and B2 = 71

Excelchat Expert
08/06/2018 - 03:12

and then it divide divided by A2

Excelchat Expert
08/06/2018 - 03:12

That will becomes value in #2

User
08/06/2018 - 03:14

sum of A1 is 71, sum of B1 is 47 on my sheet total is 118. looking for formula to get average that equals 0.601

User
08/06/2018 - 03:15

for C1

Excelchat Expert
08/06/2018 - 03:17

If you input value in C2 and A2, the a corresponding value will be calculated in B2

User
08/06/2018 - 03:18

How about this I know excel has a formula for this just a matter of figuring it out lol. Sorry not trying to be difficut

Excelchat Expert
08/06/2018 - 03:19

I'm not quite sure what is your question

User
08/06/2018 - 03:21

A1 equals 71, B1 equals 47 the sum of the 2 is 118. What is the formula to get the divided decimal for C1

User
08/06/2018 - 03:22

that would equal 0.601

User
08/06/2018 - 03:31

excel colum A, colum B sum, divided by colum A

User
08/06/2018 - 03:36

Thank you for your non help

Excelchat Expert
08/06/2018 - 03:37

Well, I believe I have answered your question regarding the calculation questions you asked

User
08/06/2018 - 03:37

no that you haven't

Excelchat Expert
08/06/2018 - 03:38

I am not sure what you are asking except the solution that I have provide you based on the questions you asked

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