Sometihng like this:

=COUNTIF(OFFSET($B$1,INT((ROW(A1)-1)*3),,3),"Find me")

--
Best Regards,

Luke M
"sly411" wrote in message
...
Cell A1 countsif a value appears in cells b1; b2 or b3. I want to copy
cell
A1 into cell A2 etc but want the countsif reference to jump to b4; b5 or
b6.
Currently if I copy it down to A2 the reference changes to b2; b3 and b5.

I need to copy hundreds of cells like this and I'm trying to avoid doing
it
manually.