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...