Problem getting values

  • Thread starter Excel worksheet funtions
  • Start date
E

Excel worksheet funtions

How can I calculate ages for example I have colums with ages and I need to
know how many people between of age of 20 to 30?
 
T

T. Valko

Do you mean >=20 but <= 30?

Try one of these:

=COUNTIF(A1:A10,">=20")-COUNTIF(A1:A10,">30")

=INDEX(FREQUENCY(A1:A10,{20,30}-{1,0}),2)

=SUMPRODUCT(--(A1:A10>=20),--(A1:A10<=30))

--
Biff
Microsoft Excel MVP


"Excel worksheet funtions" <Excel worksheet
[email protected]> wrote in message
news:[email protected]...
 
Top