Want to drag formula to new cells but only change one part

I have this formula; =COUNTIFS(Tally!D188:D203, "X", Tally!E188:E203, ">=3")/COUNTIF(Tally!D188:D203, "X")*100

I would like to drag this down the column, row by row and have it advance by column on one part of the formula.. For example;

=COUNTIFS(Tally!D188:D203, "X", Tally!E188:E203, ">=3")/COUNTIF(Tally!D188:D203, "X")*100

=COUNTIFS(Tally!D188:D203, "X", Tally!F188:F203, ">=3")/COUNTIF(Tally!D188:D203, "X")*100

=COUNTIFS(Tally!D188:D203, "X", Tally!G188:G203, ">=3")/COUNTIF(Tally!D188:D203, "X")*100

=COUNTIFS(Tally!D188:D203, "X", Tally!H188:H203, ">=3")/COUNTIF(Tally!D188:D203, "X")*100

=COUNTIFS(Tally!D188:D203, "X", Tally!I188:I203, ">=3")/COUNTIF(Tally!D188:D203, "X")*100

I've tried using the $, but it does not seem to work.