View Single Post
  #4   Report Post  
Wilbur Chua Wilbur Chua is offline
Member
 
Posts: 47
Default Countifs

Hello!

Using the COUNTIF and COUNTIFS formula will allow you to count how many a

1) under30
2)30 to 40
3)40 to 50
4)50 to 60
5)older

So for under 30 and above 60, it's just a COUNTIF formula:
=Countif(Range, criteria)
Range is just column where the age is, then criteria is "<30", and "60"

For the middle ages, just do the COUNTIFS Formula:
=countifs(creteria_range1,Criteria1,Criteria_range 2,Criteria2...)
IN this case, Range is the same for all, but the criteria 1 is "30", then criteria 2 is "<40", so on and so forth.

Hope this helps!