On Thu, Oct 14, 2010 at 7:03 AM, Srinivasan Ethirajalu < srinivasan.ethiraj...@gmail.com> wrote:
> Function_num > (includes hidden values) Function_num > (ignores hidden values) Function 1 101 AVERAGE 2 102 COUNT 3 103 COUNTA 4 > 104 MAX 5 105 MIN 6 106 PRODUCT 7 107 STDEV 8 108 STDEVP 9 109 SUM 10 110 > VAR 11 111 VARP > > > *use =subtotal(109,your-range)* > Note: 109 stands for SUM with ignores hidden values > > > > > On Thu, Oct 14, 2010 at 6:53 AM, Srinivasan Ethirajalu < > srinivasan.ethiraj...@gmail.com> wrote: > >> >> >> On Thu, Oct 14, 2010 at 6:49 AM, Srinivasan Ethirajalu < >> srinivasan.ethiraj...@gmail.com> wrote: >> >>> use =subtotal(9,your-range) >>> >>> Note: 9 stands for SUM >>> Please check the help for other function-num in help file. >>> >>> >>> >>> >>> >>> >>> On Thu, Oct 14, 2010 at 12:26 AM, Rajesh K R <rajeshkainikk...@gmail.com >>> > wrote: >>> >>>> hi srinivasan >>>> thanks for your answer, but i have one more doubt is it possible to >>>> get a sum of the filtered values using a macro or formula. >>>> >>>> expecting your answer. >>>> >>>> regards >>>> >>>> rajesh >>>> >>>> On 10/11/10, Srinivasan Ethirajalu <srinivasan.ethiraj...@gmail.com> >>>> wrote: >>>> > updated one.... >>>> > >>>> > >>>> > On Mon, Oct 11, 2010 at 10:41 PM, Srinivasan Ethirajalu < >>>> > srinivasan.ethiraj...@gmail.com> wrote: >>>> > >>>> >> refer the attachment >>>> >> >>>> >> Srinivasan >>>> >> >>>> >> >>>> >> On Mon, Oct 11, 2010 at 10:21 PM, Rajesh K R >>>> >> <rajeshkainikk...@gmail.com>wrote: >>>> >> >>>> >>> HI ALL EXPERRTS >>>> >>> >>>> >>> IS THERE ANY WAY TO FILTER THE DATA 1/10/10 TO 10/10/10 IN EXCEL, >>>> >>> >>>> >>> THANKS IN ADVANCE TO HELP ME. >>>> >>> >>>> >>> RAJESH KAINIKKARA >>>> >>> >>>> >>> -- >>>> >>> >>>> >>> >>>> ---------------------------------------------------------------------------------- >>>> >>> Some important links for excel users: >>>> >>> 1. Follow us on TWITTER for tips tricks and links : >>>> >>> http://twitter.com/exceldailytip >>>> >>> 2. Join our LinkedIN group @ >>>> http://www.linkedin.com/groups?gid=1871310 >>>> >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>> >>>> >>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>> >>>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>>> >>> Like our page on facebook , Just follow below link >>>> >>> >>>> >>> >>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >>>> >>> >>>> >> >>>> >> >>>> >> >>>> >> -- >>>> >> Srinivasan Ethirajalu, >>>> >> +919840544295 >>>> >> >>>> > >>>> > >>>> > >>>> > -- >>>> > Srinivasan Ethirajalu, >>>> > +919840544295 >>>> > >>>> > -- >>>> > >>>> ---------------------------------------------------------------------------------- >>>> > Some important links for excel users: >>>> > 1. Follow us on TWITTER for tips tricks and links : >>>> > http://twitter.com/exceldailytip >>>> > 2. Join our LinkedIN group @ >>>> http://www.linkedin.com/groups?gid=1871310 >>>> > 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> > 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> > >>>> > To post to this group, send email to excel-macros@googlegroups.com >>>> > >>>> > <><><><><><><><><><><><><><><><><><><><><><> >>>> > Like our page on facebook , Just follow below link >>>> > >>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >>>> > >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> >>>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >>>> >>> >>> >>> >>> -- >>> Srinivasan Ethirajalu, >>> +919840544295 >>> >> >> >> >> -- >> Srinivasan Ethirajalu, >> +919840544295 >> > > > > -- > Srinivasan Ethirajalu, > +919840544295 > -- Srinivasan Ethirajalu, +919840544295 -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
filter summation updated.xls
Description: MS-Excel spreadsheet