Help please

Z

zendakin

This is probably something really silly but can anyone tell me how I can
do this?

In one row I have ten columns to fill out.

The first columns formula is as follows.
=COUNTIF('Eval 1'!$R$21:$R$33,"x")

How do I make a formula for this so I don't have to change the 1 in
'Eval 1' 9 times per row? I'd like to drag it so I can type the forumla
once and have it read something like this.

=COUNTIF('Eval 1'!$R$21:$R$33,"x")
=COUNTIF('Eval 2'!$R$21:$R$33,"x")
=COUNTIF('Eval 3'!$R$21:$R$33,"x")
=COUNTIF('Eval 4'!$R$21:$R$33,"x")
.....
=COUNTIF('Eval 10'!$R$21:$R$33,"x")

There has to be a way I just don't know where to look.

Any ideas?

Thanks in advance.

~M
 
B

Bob Umlas

If the formula is in row 1:
=COUNTIF(INDIRECT("'Eval "&ROW()&"'!$R$21:$R$33"),"x")
 
R

RagDyer

If I read the OP correctly Bob, I believe that he's looking to copy the
formula across columns, within the same row!

So, to slightly revise your formula to take this into consideration:

=COUNTIF(INDIRECT("'Eval "&COLUMN(A:A)&"'!$R$21:$R$33"),"x")
 
Top