Problem getting values

[Guest]

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?

 

[Guest]

=SUMPRODUCT((A1:A100>=20)*(A1:A100<=30))



"Excel worksheet funtions" skrev:

 

[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
(e-mail address removed)> wrote in message
news:[email protected]...