countif

[cp]

I am trying to count a range of numbers in a column I
created in excel to see how many times a particlar range
appears. For example, I have a column with 10 rows that
has a unique zip codes in each of the cells.

90001
90003
91005
90009
90207
94001
96007
97009
98009
98991

I want to know how many times each number below 94000
occurs and how many instances in which numbers greater
than 94000 occur.

What formula do I use.

Thank you.

cp

 

[RagDyer]

Data in A1 to A10.
Try this:
=COUNTIF(A1:A10,">94000")&" above 94000 and "&COUNTIF(A1:A10,"<94000")&"
below 94000"
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I am trying to count a range of numbers in a column I
created in excel to see how many times a particlar range
appears. For example, I have a column with 10 rows that
has a unique zip codes in each of the cells.

90001
90003
91005
90009
90207
94001
96007
97009
98009
98991

I want to know how many times each number below 94000
occurs and how many instances in which numbers greater
than 94000 occur.

What formula do I use.

Thank you.

cp

 

[Don Guillett]

Have a look in HELP index for COUNTIF

 

[cp]

I tried but could not figure it out, hence my reason for
contacting this support group.

cp

 

[Don Guillett]

One of the examples given is what RD suggested
example:
=COUNTIF(B2:B5,">55") Number of cells with a value greater than 55 in
the second column above (2)

 

[CLR]

Another thing you might be interested in is the Data > Subtotals
procedure.........it will tell you how many times EACH number
appears............

Vaya con Dios,
Chuck, CABGx3

 

[Ragdyer]

Must be nice to have a leisurely Sunday, where one can find the time to go
back into the NGs, and read the old postings!