Help please
 

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


--
zendakin
------------------------------------------------------------------------
zendakin's Profile: http://www.excelforum.com/member.php...o&userid=25162
View this thread: http://www.excelforum.com/showthread...hreadid=386589

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

"zendakin" wrote in
message ...

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


--
zendakin
------------------------------------------------------------------------
zendakin's Profile:
http://www.excelforum.com/member.php...o&userid=25162
View this thread: http://www.excelforum.com/showthread...hreadid=386589

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")

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

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

"zendakin" wrote
in
message ...

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


--
zendakin
------------------------------------------------------------------------
zendakin's Profile:
http://www.excelforum.com/member.php...o&userid=25162
View this thread:
http://www.excelforum.com/showthread...hreadid=386589