I am trying to make my indirect formula draggable across a row, I have tried using ADDRESS function but I can't seem to get it work right for me:
=COUNTIFS(C$3:INDIRECT("C"&$B$65),"2",$A$3:INDIRECT("A"&$B$65),"*&*")
At the moment I am manually editting the formula for each cell, but I am sure there is a way of getting the drag to work?