COUNTIF NAME RANGE

T

Todd

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to get the sum of B:C by counting the instances that a nameappears in range A 8
Complicated Formula Problem 10
VBA Coding Help for Beginner 0
Average Question 2
Countif function giving incorrect answer 5
countif on multiple criteria 1
Finding the Percentage % in 2 Numbers 2
Locate text in range (multiple occurrences) and report other cell insame column? 25

Top