Saturday, January 18, 2014

yogi_Work With Data From Another Sheet Based On Cell Ranges As Noted on Host Sheet

                                          Google Spreadsheet   Post  #1488
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-17-2014
post by Ersun Gublas (http://productforums.google.com/forum/?zx=kae787shquy7&usp=sheets_web#!category-topic/docs/spreadsheets/3MN9GuDI-GE)
new sheets formula problem
Hi,
I want to transfer my old sheets to new sheets.
So i download them as xlsx and upload again.
All works fine until i face below formula.

This formula works in old sheets and downloaded excel, but not in new sheets, it gives formula parse error.

=sumif(indirect("Masraflar!G"&E$2):indirect("Masraflar!G"&F$2),$B15,indirect("Masraflar!i"&E$2):indirect("Masraflar!i"&F$2))

Regards,
---
The old version of sheets:

Converted new sheet version:
----------------------------------------------------------------------------------------------