ExcelBanter - Escel: Count students =20 and <=29

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Escel: Count students =20 and <=29 (https://www.excelbanter.com/excel-discussion-misc-queries/116737-escel-count-students-%3D20-%3D29.html)

Carlos

Escel: Count students =20 and <=29

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.

Ron Rosenfeld

Escel: Count students =20 and <=29

On Mon, 30 Oct 2006 13:40:02 -0800, Carlos
wrote:

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.

Something like:

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

should work.

--ron

All times are GMT +1. The time now is 11:50 AM.