Counting
 

I am having difficulty performing a count. I have a column of values,
which I put into several categories. Say the values range from 0 to 30, and a
category is numbers between 5 and 10. . I want to count the number of times a
value in the column equals a number in a category, say between 5 and 10 for
my example. For example, among the following values (4, 3, 8, 13, 10, 5, 1),
the answer would be 3 (for 8, 10 and 5).
I have tried a number of COUNT and SUM functions to no avail. Most
only give me the opportunity to put a condition of say "4" but nothing like
"5<=x<=10". I would appreciate any specific help. Thank you!

=COUNTIF(A:A,"<=10")-COUNTIF(A:A,"<5")

Vaya con Dios,
Chuck, CABGx3


"wjmd" wrote in message
...

I am having difficulty performing a count. I have a column of
values,
which I put into several categories. Say the values range from 0 to 30,
and a
category is numbers between 5 and 10. . I want to count the number of
times a
value in the column equals a number in a category, say between 5 and 10
for
my example. For example, among the following values (4, 3, 8, 13, 10, 5,
1),
the answer would be 3 (for 8, 10 and 5).
I have tried a number of COUNT and SUM functions to no avail. Most
only give me the opportunity to put a condition of say "4" but nothing
like
"5<=x<=10". I would appreciate any specific help. Thank you!