Please ElaKiri

[wdishan]

How solve the follwing formular in excel

Age Range

1,2,3,1,5,6,12,16,35,48,65,14,16,

the above values are in cells i need to get the following values

Age beetween 1-10?

Age beetween 10-20?


Age beetween 20-50?


Age beetween 50-100?


Ane Please gve me the formular to solve there problems.

 

[booleanB]

danne ne

 

[Clerk_Kent]

opps..sorry machan...exel knowledge nil

 

[kitty***]

mata oyata help karanna puluwani, et oyage prob: eka therenna hariyata..

 

[Pentagram]

opps..sorry machan...exel knowledge nil

 

[asanka10]

oops srry wenna one,,,,

 

[Beetle_Bailey]

Machan mekata Array Formula ekak use karapan..

For example suppose your given values are from A1 : A13

Formula to get count where age is between 0 and 10 would be :

=SUM((A1:A13>0)*(A1:A13<11))

type above formula and pres Ctrl + Shift + Enter.

( machan normal formula ekaka wage enter press kalata enne naha)

After pressing Ctrl + Shift + Enter above formula will look like :

{=SUM((A1:A13>0)*(A1:A13<11))}

which will give you the result 6.

Remaining conditions would be similar :

{=SUM((A1:A13>10)*(A1:A13<21))}

{=SUM((A1:A13>20)*(A1:A13<51))}

{=SUM((A1:A13>50)*(A1:A13<101))}


Machan mama podi kale indan kana allanna one nam oluwa waten atha genihin allanne.. Samaharawita meeta wadiya lesi methods athi harida

 

[wdishan]

WOW thanks Brother Beetle its working fantastic Thanks You Again

 

[anarkalee]

danne ne

 

[Deelaka]

Sorry bro. danne ne

 

[gpindika]

Danne Nathooooooooo

 

[dilrasan]