in order to drag formula we lock the cell reference by putting $ sign. like
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...