# Pulling Data from a different workbook and dividing by more data from that workbook into a new workbook

#### Jenni5309

##### New Member
Hi. This is my 1st post in a forum...so bear with me please. I need help!

I need to pull data to a new workbook from a single cell in a range of sheets out of an existing workbook and divide it by another cell in that same range of sheets from that workbook. I have looked and the closest formula I can come up with is this: =SUM('[January2014Fuelandmileage]5:11'!B57/'[January2014Fuelandmileage]5:11'!B116), but I am getting the dreaded '#REF!'.

I am not an excel expert by any means but usually can come up with a formula when I need one...I am stumped. If anyone can help, I would be eternally grateful.

Thanks!

### Excel Facts

Author John Walkenbach was Mr Spreadsheet until his retirement in June 2019.
What I am trying to do is take the total miles (B57, sheets 5-11) and divide them by the total gallons (B116, sheets 5-11) from one workbook and have the end result (MPG) in a new workbook. I hope this clears up any questions about my dilemma. Thanks, Jenni.

Replies
0
Views
105
Replies
10
Views
412
Replies
1
Views
284
Replies
0
Views
97
Replies
11
Views
331

1,203,640
Messages
6,056,491
Members
444,869
Latest member
tulo spont

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back