Countif using a named range
 

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 using a named range
 

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

Countif using a named range
 

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!

Countif using a named range
 

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

Countif using a named range
 

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!