How do I count a range of numbers in a column?

[SLB]

I thought I posted this about an hour ago but it's not showing up so please
fogive the repeat if it does show up twice (obvioulsy I need help with this)!
I have a column of codes that are numbered for different locations on the
body. The numbers range from 1-93 and there are about 748 entries in the
column. I only need to know how many of them are located on the face.
Therefore, I only need to know how many cells contain the numbers 1-5, 10-13,
60-69, 70-79, or 80-89. I can't seem to figure out how to make excel count
only these numbers. Any help at all would be greatly appreciated!!
-sophia

 

[Paul Corrado]

=SUMPRODUCT((A1:A10>=1)*(A1:A10<=5))+=SUMPRODUCT((A1:A10>=10)*(A1:A10<=13))+
.....

 

[Arvi Laanemets]

Hi

For range 1-5
=SUMPRODUCT((A1:A748>=1)*(A1:A748<=5))

Arvi Laanemets

 

[Domenic]

To count how many cells contain the numbers 1 to 5...

=SUMPRODUCT(COUNTIF(A1:A748,ROW(INDIRECT("1:5"))))

To count how many cells contain the numbers 10 to 13...

=SUMPRODUCT(COUNTIF(A1:A748,ROW(INDIRECT("10:13"))))

....and so on.

If you want an overall count of cells containing all of the numbers you
specify...

=SUMPRODUCT(COUNTIF(A1:A748,E1:E10))

....where E1:E10 contain the numbers of interest. Of course, you can
expand the list and change the reference accordingly.

Hope this helps!

 

[Don Guillett]

I ans this in misc. Pls don't multi or cross post.

try this. Just continue to add conditions. the + means AND.
Name your range as I have done.

=SUMPRODUCT((rngI>0)*(rngI<6)+(rngI>9)*(rngI<14))

 

[SLB]

Thank you! I will try these suggestions and hopefully not have to write back!
Sorry for the double post, I'm new here and I guess I posted to the wrong
group first!
Thanks again,
Sophia