Luc,

Try this:

=COUNTIF(INDIRECT(Division),D2)

hth,

Doug

"Luc" wrote in message
...
A cell in the sheet 'PARAMETES' contains 'Communications!F:F'
I have named this range 'Division'

When i use the code below in the PARAMETERS sheet:
=COUNTIF(Communications!F:F;D2)
I get the right result

But when i use the code below in the PARAMETERS sheet:
=COUNTIF(Division;D2)
i get 0 (which is not correct)

????

What's wrong ??


Thanx,


Luc





--------------------------------------------------------------------------------
Mijn Postvak In wordt beschermd door SPAMfighter
323 spam-mails zijn er tot op heden geblokkeerd.
Download de gratis SPAMfighter vandaag nog!