I have create a chart with age and its count in excel. How can I count the number of people in age 1,2,3,4..14.
Age
4
3
10
8
2
5
5
4
6
2
1
8
4
9
5
8
12
8
4
10
1
7
8
Please help!
What do you mean by in age 1...14? To what I understand, you can use countif function. A possible answer for your question can be seen here
Clear instruction and syntax can be seen here
I will summarise:
So you this is the function countif (range
,criteria
).
range
indicates the ranges of excel fields you will count
criteria
indicates the rules of the fields.
For example =countif (A1:A3,"apple"). The function will count from field A1 to field A3. If the field has value of "apple" it will be counted.
Collected from the Internet
Please contact [email protected] to delete if infringement.
Comments