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!

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

Luc,

Try this:

=COUNTIF(INDIRECT(Division),D2)

hth,

Doug

"Luc" <(E-Mail Removed)> wrote in message
news:45e60b46$0$11264$(E-Mail Removed)...
>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!
>

=COUNTIF(INDIRECT(Division);D2)

--
---
HTH

Bob

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



"Luc" <(E-Mail Removed)> wrote in message
news:45e60b46$0$11264$(E-Mail Removed)...
>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!
>

Many thanxxxxx mate :=)

That did the job!!!


Luc


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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!