I am using the countif function and it currently reads

=countif('jimmy'!g10:g203,a12)

jimmy refers to the name of the sheet the formula works on

I want to remove the name 'jimmy' from the formula and instead replace it with a cell reference refering to a cell on the same sheet as the formula. So for instance cell B50 has the word 'jimmy' in there.

The result would be exactly the same however it would mean i could just change the B50 cell data from say jimmy to fred and that would inturn change the worksheet that the formula is looking in.

Sounds easy but i cant work it out.

Any help would be really appreciated

Darren