Locking reference of "columns of TABLE" in formula

[Hrishi]

Hello,
in order to drag formula we lock the cell reference by putting $ sign. like
=+COUNTIFS($A$5:$A$50,AI$10,$D$5:$D$50,$B11)

If my data in in "TABLE" then above formulate appears like
=+COUNTIFS(Table134[Building],AI$10,Table134[Type of Sale],$B11)
If I drag this horizontally, reference of "Table134[Building] changes to next column,

How can I lock it so that columns reference would not change?
Plz guide.

 

[Tetra201]

Try using Table134[[Building]:[Building]]

 

[Hrishi]

Ya its perfect, Thanks a lot,