 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008To count how many are in a certain age group
Hi! I'm looking for at forumla to count how many are in a certain age group. I have a list of people and their ages and would like to know how many are in the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on  SignatureLEG =COUNTIF(A2:A500,">=30")-COUNTIF(A2:A500,">39") do the same for the other age groups another way =SUMPRODUCT(--(A2:A500>=30),--(A2:A500<=39)) SignatureRegards, Peo Sjoblom > Hi! I'm looking for at forumla to count how many are in a certain age > group. > I have a list of people and their ages and would like to know how many are > in > the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on Thanks, sumproduct worked! My Danish excel03 couldn't figure countif out. SignatureLEG "Peo Sjoblom" skrev: > =COUNTIF(A2:A500,">=30")-COUNTIF(A2:A500,">39") > [quoted text clipped - 9 lines] > > in > > the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on Here is the Danish version =TÆL.HVIS(A2:A500;">=30")-TÆL.HVIS(A2:A500;">39") SignatureRegards, Peo Sjoblom > Thanks, sumproduct worked! My Danish excel03 couldn't figure countif out. >> =COUNTIF(A2:A500,">=30")-COUNTIF(A2:A500,">39") [quoted text clipped - 11 lines] >> > in >> > the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on one way, don't forget the = if it is less than or equal to. =COUNT(IF(AND(B1:B4<40,B1:B4>30),B1:B4)) this is known as an array formula, when you finish typing it instead of just hitting enter you need to hit ctl-shift-enter. if you see {} around the formula you did it right. Signature-John Please rate when your question is answered to help us and others know what is helpful. > Hi! I'm looking for at forumla to count how many are in a certain age group. > I have a list of people and their ages and would like to know how many are in > the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on Hi Thanks, but "count, if, and" didn't work even if I got {} to make sure I did it correctly. Probably because I have a Danish version of Excel 03 and couldn't translate. Something to do with commas and semicolons. I used "sumproduct" and that worked. But thanks for responding. SignatureLEG "John Bundy" skrev: > one way, don't forget the = if it is less than or equal to. > =COUNT(IF(AND(B1:B4<40,B1:B4>30),B1:B4)) [quoted text clipped - 5 lines] > > I have a list of people and their ages and would like to know how many are in > > the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on Another option: =SUMPRODUCT(--(FLOOR(H2:H200,10)=30)) etc. SignatureHTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings sandymann2@mailinator.com Replace @mailinator.com with @tiscali.co.uk > Hi! I'm looking for at forumla to count how many are in a certain age > group. > I have a list of people and their ages and would like to know how many are > in > the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on Hi - thanks for responding, but as I do know the Danish word for "floor", I can't figure out what it means when put together with the formula "sumproduct" and what it should do. And neither does the Danish help program! But I did use a sumproduct formula which worked. SignatureLEG "Sandy Mann" skrev: > Another option: > [quoted text clipped - 7 lines] > > in > > the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on Sandy SUMPRODUCT is a pretty powerful function and I continue to find new uses for it; but, it seems like the FREQUENCY function was pretty much made for your situation. You might want to break out the old English- Danish dictionary and see if that function will work for you. Good luck. Ken Norfolk, Va > Hi - thanks for responding, but as I do know the Danish word for "floor", I > can't figure out what it means when put together with the formula [quoted text clipped - 30 lines] > > - Show quoted text - A1:A20 = age (as an integer) C1 = 30 D1 = 39 =INDEX(FREQUENCY(A$1:A$20,C1:D1-{1,0}),2) SignatureBiff Microsoft Excel MVP Sandy SUMPRODUCT is a pretty powerful function and I continue to find new uses for it; but, it seems like the FREQUENCY function was pretty much made for your situation. You might want to break out the old English- Danish dictionary and see if that function will work for you. Good luck. Ken Norfolk, Va On May 7, 3:12 pm, LEG <L...@discussions.microsoft.com> wrote: > Hi - thanks for responding, but as I do know the Danish word for "floor", > I [quoted text clipped - 34 lines] > > - Show quoted text - I like that one! SignatureBiff Microsoft Excel MVP > Another option: > [quoted text clipped - 7 lines] >> are in >> the age group f.eks. between the ages of 30 and 39, 40 and 49 and so on |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.