Escel: Count students >=20 and <=29

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use countif to count number of students whose age is greater
or equal to 20 but less than or equal to 29. Can this be done? Is countif
the correct formula? Please answer.
 
I am trying to use countif to count number of students whose age is greater
or equal to 20 but less than or equal to 29. Can this be done? Is countif
the correct formula? Please answer.
Click to expand...


Something like:

=COUNTIF(Ages,">=20") - COUNTIF(Ages,">29")

should work.


--ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
Excel Excel 2007 Formula Help Needed 1
Counting Problem 2
Counting Cells with Multiple Range Criteria (Excel 2003) 7
countif 3
Help: Using CONCATENATE (and a COUNT?) for a total result 3
How to locate which cells add up less than or equal to a certainnumber (where numbers can be repeate 1
Greater than or less than formula 3

Back
Top