G
Guest
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!
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!