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:

https://docs.google.com/spreadsheet/ccc?key=0AolRFEUlYoOqdGNRQ2ViVVFtMWd2RDhaakRScXpLMnc&usp=sharing

Converted new sheet version:

https://docs.google.com/spreadsheets/d/1bB75CrteTSygYDVf853sFuk4kond_noBHl2PfP9uz-o/edit?usp=sharing

----------------------------------------------------------------------------------------------