Excel - AVERAGE Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I have a fuels calibration table previously done in Excel. The process is to dip a long ruler into the top of the tank, hit the bottom and pull it out. The level of the fuel is then read from the spreadsheet. The current spreadsheet is broken into 1/8" increments and I must now break it down further into 1/16" increments. I am aware that Excel is not friendly to feet and inches and I have a work around. The problem is when I try to take the number of gallons from the previous sheet and populate my new sheet. The numbers go into the cells fine and I even have a formula to take the average between the two. The problem, is that with the previous worksheet in 1/8's and the new one in 1/16's I cannot figure out how to make the cells search for their data relatively on the smaller spread sheet. Any ideas?
Solved by E. E. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 04/03/2018 - 07:53
Hello there, thanks for choosing Got It Pro - Excel.
User 04/03/2018 - 07:53
Youre' welcome
Excelchat Expert 04/03/2018 - 07:53
Can you please attach your file here ?
User 04/03/2018 - 07:55
Do you work in 2013 my computer will not show the file in your upload directory.
Excelchat Expert 04/03/2018 - 07:56
I work in 2011
User 04/03/2018 - 07:58
Maybe we can do this with your open spreadsheet
Excelchat Expert 04/03/2018 - 07:58
Can you please attach and then will see if iy works
User 04/03/2018 - 07:58
It won't attach
User 04/03/2018 - 07:59
Can you see the spreadsheet on my screen
Excelchat Expert 04/03/2018 - 07:59
Yes if you can copy and paste here in google sheet
Excelchat Expert 04/03/2018 - 08:00
We both can see the data in google sheet
User 04/03/2018 - 08:01
My problem is that I have to add col b and average the two numbers
User 04/03/2018 - 08:02
I have figured out a way to expand the spread sheet to allow for the 1/16
Excelchat Expert 04/03/2018 - 08:02
To get the average of B4 and B5 ?
Excelchat Expert 04/03/2018 - 08:07
Are you there >
Excelchat Expert 04/03/2018 - 08:11
Hello ?
Excelchat Expert 04/03/2018 - 08:11
Please check in B6 cell.
Excelchat Expert 04/03/2018 - 08:11
The time is running out for us.
Excelchat Expert 04/03/2018 - 08:12
Hope we helped you, if you need our help please post again.
Excelchat Expert 04/03/2018 - 08:12
Thanks for choosing Got It Pro - Excel, please give your kind feedback for our service.
Excelchat Expert 04/03/2018 - 08:12
Have a good day ahead :)

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
The Allstate Corporation
United Parcel Service
Dell Inc