Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count age ranges
Hi all, can someone please help, I'm trying to count the number of 18-21, 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,"=18") which counts the 18 y.o's and above, but not each oh the age ranges. I don't know how to get the other ages to calculate. many thanks -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=551400 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
count age ranges
You may use try:
=SUMPRODUCT(--($I$3:$I$10=18),--($I$3:$I$10<22)) Change the ranges and values as appropiate Hope this helps, Miguel. "Clash" wrote: Hi all, can someone please help, I'm trying to count the number of 18-21, 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,"=18") which counts the 18 y.o's and above, but not each oh the age ranges. I don't know how to get the other ages to calculate. many thanks -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=551400 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
count age ranges
Hi
=COUNTIF($I$3:$I$10,"=18")-COUNTIF($I$3:$I$10,"<=21") -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "Clash" wrote in message ... Hi all, can someone please help, I'm trying to count the number of 18-21, 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,"=18") which counts the 18 y.o's and above, but not each oh the age ranges. I don't know how to get the other ages to calculate. many thanks -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=551400 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
count age ranges
=COUNTIF($I$3:$I$10,"=18") -COUNTIF($I$3:$I$10,"21")
etc. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Clash" wrote in message ... Hi all, can someone please help, I'm trying to count the number of 18-21, 22-26, etc in a column. My attempt is =COUNTIF($I$3:$I$10,"=18") which counts the 18 y.o's and above, but not each oh the age ranges. I don't know how to get the other ages to calculate. many thanks -- Clash ------------------------------------------------------------------------ Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951 View this thread: http://www.excelforum.com/showthread...hreadid=551400 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count consecutive dates only | Excel Discussion (Misc queries) | |||
Count rows that match criteria in 2 different column cell ranges | New Users to Excel | |||
How do I count cells in a column of dates between date ranges? | Excel Worksheet Functions | |||
Formula that will count between dates ranges | Excel Worksheet Functions | |||
Formula that will count between dates ranges | Excel Worksheet Functions |