Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I'm using a simple Countif in XL2003 so don't need to CSE it. It fights with
a named range and I cannot see why. It worked when I set it up, but the moment I changed anything it stopped. Where am I going wrong? Given a 50-cell range $B$20:$B$44 and $B$56:$B$80 named as F_Shell. Formula =COUNTIF(F_Shell,"0"). This returns #VALUE, but it returns the correct number if I use the cell references. I've tried entering it as a CSE: no change. I've tried the suggestion from other questions in this forum to ensure it is not text format, but general + double-click + enter: no change. I'd appreciate any pointers. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can't chart dynamic named range?? | Charts and Charting in Excel | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
VLookup Error in Part of a Named Range | Excel Worksheet Functions | |||
Updating a named range | Excel Worksheet Functions | |||
Range matching multiple named Ranges | Excel Discussion (Misc queries) |