Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count within a range
Hi Guys Column 1 is a number between -1 and 30 I need to know the: Number of occurences between -1 and 5 Number of occurences between 6 and 10 Number of occurences between 11 and 15 Number of occurences between 16 and 30 Any ideas... count if..? *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count within a range
=SUMPRODUCT(--(A1:A100=-1),--(A1:A100<-5))
etc. -- HTH RP (remove nothere from the email address if mailing direct) "Darin Kramer" wrote in message ... Hi Guys Column 1 is a number between -1 and 30 I need to know the: Number of occurences between -1 and 5 Number of occurences between 6 and 10 Number of occurences between 11 and 15 Number of occurences between 16 and 30 Any ideas... count if..? *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count within a range
for a countif solution
=count(A:A)-Countif(A:A,"5") =countif(A:A,"5")-Countif(A:A,"10") =Countif(A:A,"10")-Countif(A:A,"15") =Countif(A:A,"15") -- Regards, Tom Ogilvy "Darin Kramer" wrote in message ... Hi Guys Column 1 is a number between -1 and 30 I need to know the: Number of occurences between -1 and 5 Number of occurences between 6 and 10 Number of occurences between 11 and 15 Number of occurences between 16 and 30 Any ideas... count if..? *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count within a range
Perfect - THanks RP, If I wanted to add a further complication... Say column 2 was either A, B or C so I Want all the occurences of type A which are more than -1 and greater than 5 etc... possible...? Regards DK *** Sent via Developersdex http://www.developersdex.com *** |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count within a range
Yes it is
=SUMPRODUCT((A1:A100=-1)*(A1:A100<=5)*(B1:B100={"A","B","C"})) -- HTH RP (remove nothere from the email address if mailing direct) "Darin Kramer" wrote in message ... Perfect - THanks RP, If I wanted to add a further complication... Say column 2 was either A, B or C so I Want all the occurences of type A which are more than -1 and greater than 5 etc... possible...? Regards DK *** Sent via Developersdex http://www.developersdex.com *** |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count within a range
For just type A as asked it would be:
=SUMPRODUCT((A1:A100=-1)*(A1:A100<=5)*(B1:B100="A")) or =SUMPRODUCT((A1:A100=-1),(A1:A100<=5),--(B1:B100="A")) -- Regards, Tom Ogilvy "Bob Phillips" wrote in message ... Yes it is =SUMPRODUCT((A1:A100=-1)*(A1:A100<=5)*(B1:B100={"A","B","C"})) -- HTH RP (remove nothere from the email address if mailing direct) "Darin Kramer" wrote in message ... Perfect - THanks RP, If I wanted to add a further complication... Say column 2 was either A, B or C so I Want all the occurences of type A which are more than -1 and greater than 5 etc... possible...? Regards DK *** Sent via Developersdex http://www.developersdex.com *** |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count within a range
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count Vaules in a range that appear in another range | Excel Worksheet Functions | |||
Multiple Criteria, Count If, Sum Product to get count across range | Excel Worksheet Functions | |||
How to count dates within a certain range in a column with mutiple date range entries | Excel Worksheet Functions | |||
Count cells in one range based on parameters in another range | Excel Worksheet Functions | |||
count within a range | Excel Programming |