Array Formula Not Working - Sample Attached

[Excel"*"]

I've been working with the attached formula on my Mac @ home and it works up when I use my PC running on Windows it does not work....

Any thoughts as to why this does not work. It's an array formula and I've tried to do Ctrl+Shift+Enter but no luck All help is great!!! Thank you!!

[NBVC]

Should it be like this?

=SUM(INDIRECT("'"&H1&"'!D12:"&INDEX(NAS!D12:O12,MATCH('New Sales Ops Report'!K1,NAS!D1:O1,0)-1)))

[daddylonglegs]

Isn't that the same formula you were trying to use in this thread?

None of the suggestions there are "array formulas" - normal entry should suffice.....but in general on a Mac you don't use CTRL+SHIFT+ENTER, you use COMMAND+RETURN

[Excel"*"]

Yes sorry, I have a thread titled, "Dynaimc Sum Range." The second to last post has an example of my problem...

Attached is a sample of what I'm talking about sorry. Wow this is hard. Thank you for your time!!

[daddylonglegs]

OK, please stick to that thread, I'll reply there, this one is closed