PC Review


Reply
Thread Tools Rate Thread

COUNTIF NAME RANGE

 
 
Todd
Guest
Posts: n/a
 
      24th May 2011
I have one worksheet called with column A1:A72 filled with 6 digit
numbers in each cell - i.e. 239260 (A1), 239060 (A2), etc. all the way
down to A72 with 6 digit numbers.

I have a second worksheet called query parameters. On it is a named
range called SHIPSEA which is another list of 6 digit numbers in a
column that identify stations that are assigned these 6 digit numbers.
The numbers in this column identify SHIPSEA.

How do I use a CountIF formula to count the number of instances that
SHIPSEA numbers appear in the worksheet one column (A:A)?

My formula returns a zero:

=COUNTIF(A1:A72,SHIPSEA)

Thanks, Todd

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Countif using tab range DEI Microsoft Excel Worksheet Functions 3 12th Jan 2009 08:30 PM
COUNTIF to compare one range versus another range Phil Microsoft Excel Programming 3 30th May 2007 10:39 PM
Using countif with a name of a range =?Utf-8?B?d2Vic3Rlcg==?= Microsoft Excel Worksheet Functions 3 14th Jun 2006 02:37 PM
CountIF Range Michael Microsoft Excel Worksheet Functions 4 31st Jan 2006 01:27 PM
COUNTIF or not to COUNTIF on a range in another sheet =?Utf-8?B?RWxsaWU=?= Microsoft Excel Worksheet Functions 4 15th Sep 2005 10:06 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:01 PM.