Problem getting values

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Excel worksheet funtions - 19 Jul 2007 21:18 GMT

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?

Reply to this Message

excelent - 19 Jul 2007 21:56 GMT

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

"Excel worksheet funtions" skrev:

> 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?

Reply to this Message

T. Valko - 19 Jul 2007 21:58 GMT

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))

Signature

Biff
Microsoft Excel MVP

> 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?

Reply to this Message