Cell Reference Generation

  • Thread starter Thread starter Kcope8302
  • Start date Start date
K

Kcope8302

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?
 
Can you explain the equation as I will have to manipulate to more than one
column.

Thanks

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

Kcope8302 said:
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?
Click to expand...
Click to expand...
 
Back
Top