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!
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!