=COUNTIF(INDIRECT(Division);D2)

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"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!