Formulas don't work in google drive

[K DOC]

Hi,

When I upload my Excel Sheet in google Drive Formulas don't work.

I have attached "TA - Copy". Following Formula in "MASTER" Sheet in Column "C" don't work when I upload this sheet in GOOGLE DRIVE:

=SUMPRODUCT(SUMIF(INDIRECT("'R."&ROW(INDIRECT("1:12"))&"'!$A$4:$A$90"),A7,INDIRECT("'R."&ROW(INDIRECT("1:12"))&"'!$H$4:$H$90")))+D7

Please help me.

Thanks & Regards,
K DOC

[6StringJazzer]

Please explain "don't work". What result are you expecting, and what result do you get instead?

When I copy this file to my Google Drive and open it in Google Sheets it works fine.

[6StringJazzer]

I take that back. When I open it in Sheets the only cell that retains the formula is C4. The other cells below it have all been converted to values. Is that the problem you are seeing?

[6StringJazzer]

Are you still using Excel 2007? I do not have that version available for testing but I'd be surprised if that formula works in that version because it's an array formula that is not explicitly entered as such.

[K DOC]

Hi,
Thanks for your response. I am using MS Office 365.
In the sample which I have Uploaded Cells C7, G7, C9, G9, C17, G17, C25 & G25 gets populated but These are Blank when I open the same sheet in Google Drive.

[6StringJazzer]

Please update your member profile to show your current version of Excel.

I am not an expert at Google Sheets but will see what I can find out. Unfortunately Google Sheets does not have the same formula debugging features that Excel has.

[alansidman]

crossposted: https://support.google.com/docs/thread/263104262

Rule 7: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

However, if you continue to crosspost, you can expect to have your thread BLOCKED until you update it yourself.

[K DOC]

Hi alansidman,

I am extremely sorry for crossposting my query as I was not aware of Rule 7. However I have deleted my post from support.google.com and assure you that crossposting will not be repeated.

Regards,
K DOC

It is Rule 3 instead of Rule 7 as mentioned by me above.