Try
=COUNTIFS(INDIRECT("Data!R3C" & (ROW()+6) & ":" & "R200C" & (ROW()+6),0),1)

"Kcope8302" wrote:

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?