Countifs question

[jaffacake]

Hi all,

Can anyone please look at the formula below and explain what's wrong with it?

=COUNTIFS(("'"&month&"'!FTBRep"), A8,("'"&month&"'!FTBData"), "Yes")

month is a cell (named range) which is the sheet name.
FTBRep/FTBData are named ranges i'd like to test the criteria against.

Any help would be gratefully appreciated.

 

[barry houdini]

You need INDIRECT function, try

=COUNTIFS(INDIRECT("'"&month&"'!FTBRep"),A8,INDIRECT("'"&month&"'!FTBData"),"Yes")

 

[jaffacake]

Great stuff - thanks very much! I knew i was missing something simple!