Reference in the OFFSET function

Copper Contributor

Hello,

I am just learning how to use pivot tables. In an example I have found the formula: 

"=OFFSET(Summary[@[S. No.]],$O$2,0)", and Excell does not recognize it and I can't find "Summary" beetwen the functions. What does it means? 

2 Replies

@jabrito_56 , that is structured reference. Summary is the name of the Excel Table, and S.No. is column name. 

 @Sergei Baklan 

Thank you, I got it!.