Reply to thread

Message: <blockquote data-quote="Beetle_Bailey" data-source="post: 2594022" data-attributes="member: 118102">Machan mekata Array Formula ekak use karapan..For example suppose your given values are from A1 : A13Formula 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 <img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" /><img src="/styles/default/xenforo/smilies/default/happy.gif"  class="smilie" loading="lazy" alt=":)" title="Happy    :)" data-shortname=":)" /></blockquote>

Top Bottom