Excel - SUM Function Problem - Expert Solution

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.

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