Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
=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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
excel formula counting date to date in 4 columns | Excel Worksheet Functions | |||
Counting... | Excel Worksheet Functions | |||
Counting unique entries in column A but only if specific values appear in columns B and C | Excel Worksheet Functions |