Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
using COUNTIF I want to count multiple values
Hello I have a spreadsheet that I need to count up to 500 items for. For
example how many people between the ages of 19 and 29 fell. right now I am doing ((COUNTIF(a1:a500,"19")+(COUNTIF(a1:a500,"20")) and so on. I knwo there has to be an easier way! So the example below: a 1 19 2 22 3 24 4 55 5 76 6 44 I would want a b 1 19-29 3 2 30-49 1 3 50-69 1 4 70-79 1 Also if I could get help with this I also will need to count time ranges e.i. 0100 to 0900. I know there is a way to do these, but I can nto figure it out - thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNTIF Multiple Values | Excel Worksheet Functions | |||
Using COUNTIF to count based on multiple cell criteria. | Excel Worksheet Functions | |||
How do I use countif to count values excluding blank cells | Excel Worksheet Functions | |||
using =COUNTIF to count two text values | Excel Worksheet Functions | |||
Using COUNTIF to check values in multiple columns | Excel Worksheet Functions |