| 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! |
| 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 | |||
Threaded Mode
