hello

i was wondering if i could use the countif function using variables
instead of having set constants

i.e. =countif(R[-2]C[1]:RC[2],""search"")

but i want = countif(R[VAR1]C:[VAR2]:RC[2],""search"")

i cant' seem to get the VAR1 part to work..maybe its my equation or
maybe i should use a different equation..

thanks for your help


--
narutard
------------------------------------------------------------------------
narutard's Profile: http://www.excelforum.com/member.php...o&userid=25111
View this thread: http://www.excelforum.com/showthread...hreadid=386432