absolute structured references in excel table formulas?

[INKLO708]

HY,
I am stucked with the absolute structured references in excel table formulas,
currently i am using this formula for calculation as......... =ROWS($Z$8:Z20) .......while in case of table calculation this looks like as.........=ROWS([@[SR NO.]]) ...just unable to to lock thse cell.
and i need this to convert into absolute references in case of table ????

guide me this plz i need to done this absolute reference.
thanks

 

[LazyBug]

Hello!
Nope! In most cases no need to return to a range structure if you have a table one.
Formulas become more readable, the names are fixed. And entering formulas anywhere in an empty column will auto-copy to entire column!

 

[Peter_SSs]

guide me this plz i need to done this absolute reference.

You will need to give a much clearer description of exactly what you have and what you are trying to do. Giving half-formulas that are not working for you gives us little to go on.

Can you use XL2BB to post a small sample structured table and explain in relation to that what you are trying to achieve?