| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help with CountIf < and time formula please | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| How to count the number of times something occurs within a certain month | Excel Worksheet Functions | |||
| avoid retype the number more than one time withen acolumn | Excel Discussion (Misc queries) | |||
| how do i convert a number into minutes for a time of completion c. | Excel Discussion (Misc queries) | |||
Linear Mode
