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
Bookmarks