ExcelBanter - Cell Reference Generation

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Cell Reference Generation (https://www.excelbanter.com/excel-discussion-misc-queries/220327-cell-reference-generation.html)

Kcope8302

Cell Reference Generation

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?

Sheeloo[_3_]

Cell Reference Generation

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?

Kcope8302

Cell Reference Generation

Can you explain the equation as I will have to manipulate to more than one
column.

Thanks

"Sheeloo" wrote:

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?

All times are GMT +1. The time now is 12:39 AM.