Cell Reference Generation

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?
 
K

Kcope8302

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

countifs Function not giving desired result with date criteria 2
Excel Need Countifs Formula Help 0
Offset/Index/Match ... or something? 3
Can a text box use a formula or cell reference 3
Query on Use of Absolute References 2
Excel VBA 1
3 numbers in each cell aligned verticaly one number in each cell 1
Fixed/Locked cell referencing 6

Top