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 -- ---------------------------------------------------------------------------------- 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.xls
Description: MS-Excel spreadsheet