LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 138
Default Countif + Named range

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't chart dynamic named range?? [email protected] Charts and Charting in Excel 4 July 20th 06 08:30 PM
inserting a named range into new cells based on a named cell Peter S. Excel Discussion (Misc queries) 1 June 4th 06 03:53 AM
VLookup Error in Part of a Named Range Dallas64 Excel Worksheet Functions 6 April 18th 06 02:13 PM
Updating a named range joala Excel Worksheet Functions 2 March 16th 06 06:10 PM
Range matching multiple named Ranges ben simpson Excel Discussion (Misc queries) 0 March 15th 06 06:45 PM


All times are GMT +1. The time now is 04:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"