| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif and values greater than zero for a named range | Excel Worksheet Functions | |||
| can't use function 'countif' in named range | Excel Discussion (Misc queries) | |||
| can't use function 'countif' in named range | Excel Worksheet Functions | |||
| Countif + Named range | Excel Worksheet Functions | |||
| If any cell in named range = 8 then shade named range | Excel Programming | |||
Linear Mode
