Many thanxxxxx mate :=)

That did the job!!!


Luc


"Dave Peterson" wrote in message
...
maybe...

=COUNTIF(indirect(Division);D2)



Luc wrote:

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!

--

Dave Peterson

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