CountIF columnH2-H101 the number of time between ages 20-29 occurs
 

ok so i have a problem, i cant seem to answer it, im not sure if you should
use frequencey or countif!
I have a list of ages from 20 -79, and i need to find out how many times
theres a occurence for each age group ie
age group 20-29 (20,21,22,23,24 etc.....29)
age group 30-39
age group 40-49
etc etc all the way til
age group 70-79
so for age group one(20-29) i need to count from Column H2-H101 how many
times each persons age occured in the document
and it does seem to work i triend everything!
please help

CountIF columnH2-H101 the number of time between ages 20-29 occurs
 

=COUNTIF(H2:H101,"=20")-COUNTIF(H2:H101,"29")

etc.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"viabello" wrote in message
...
ok so i have a problem, i cant seem to answer it, im not sure if you
should
use frequencey or countif!
I have a list of ages from 20 -79, and i need to find out how many times
theres a occurence for each age group ie
age group 20-29 (20,21,22,23,24 etc.....29)
age group 30-39
age group 40-49
etc etc all the way til
age group 70-79
so for age group one(20-29) i need to count from Column H2-H101 how many
times each persons age occured in the document
and it does seem to work i triend everything!
please help

CountIF columnH2-H101 the number of time between ages 20-29 occurs
 

one way,

set up a small table 20,30,40,50,60,70, in cells B1 to B6
enter in C1.........
=COUNTIF(H$2:H$101,"="&B1)-COUNTIF(H$2:H$101,"="&B2)
extend down to C5
in C6 enter
=COUNTIF(H2:H101,"="&B6)

--
Greetings from New Zealand
Bill K

"viabello" wrote in message
...
ok so i have a problem, i cant seem to answer it, im not sure if you
should
use frequencey or countif!
I have a list of ages from 20 -79, and i need to find out how many times
theres a occurence for each age group ie
age group 20-29 (20,21,22,23,24 etc.....29)
age group 30-39
age group 40-49
etc etc all the way til
age group 70-79
so for age group one(20-29) i need to count from Column H2-H101 how many
times each persons age occured in the document
and it does seem to work i triend everything!
please help