Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|