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
Bookmarks