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.