Sum Product with dynamic sheet name

[jackson_hollon]

Hello,

Thanks for looking into my thread. I have attached a file here. What I need is I already have a formula in column N that will get the data from different sheet. But I found a formula on line that will allow me to pull the data with dynamic sheet name. However, it doesn't work. Could someone please help to modify the formula that makes it work? Thanks a lot.

[Kaper]

You were missing some closing doublequotes, as well as some partenesses were misplaced, so the formula shall be:

Please Login or Register  to view this content.

(note that I used rows from DISPLAY sheet - you probably deleted some rows before attaching sample on excelforum - in LAY sheet it seems to keep row 49 as the row with quarters headings)

[jackson_hollon]

Kaper,

You are right. I got it now. The formula works. Thanks a lot.