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