I have a formula[=COUNTIFS(Data!H$3:Data!H$200,1)] in cell c2 that references
another worksheet. I want to paste this formula in column C from c2:c200. I
need for the numbers to stay the same but I need for the Letter cell
reference to increase from one cell to the next.

What is the method of having that happen vertically?