Harmeet Singh <harmeet.hew...@gmail.com> escreveu:
>Hi Dave, > >Thanks for the correction and sorry for being so dumb :D. > >Warm Regards, > >Harmeet Singh >IT Analyst >McKinsey & Company >http://www.facebook.com/Harmeeet > > >On Fri, Dec 3, 2010 at 1:16 PM, Dave Bonallack ><davebonall...@hotmail.com>wrote: > >> Hi, >> Harmet, your formula is using relative values for the SUM(B2:B8) section, >> and as a result, has created errors while copying down. >> Formula in D2 should look like this: >> *=B2/SUM($B$2:$B$8)* >> Then copy down. >> Regards - Dave. >> >> ------------------------------ >> From: harmeet.hew...@gmail.com >> Date: Fri, 3 Dec 2010 11:36:59 +1100 >> Subject: Re: $$Excel-Macros$$ Own Formule in Pivot Table >> To: excel-macros@googlegroups.com >> CC: sunscel...@gmail.com >> >> >> here you go >> >> Warm Regards, >> >> Harmeet Singh >> IT Analyst >> McKinsey & Company >> http://www.facebook.com/Harmeeet >> >> >> On Thu, Dec 2, 2010 at 11:43 PM, Ramkesh Maurya <sunscel...@gmail.com>wrote: >> >> Hi All, >> >> Please tell me how i can insert my own formule in Excel. e.g 2 is 5.71% of >> 35 the Grand Total, in next column I want to sum the percentage of 2( >> i.ee5.71) + percentage of 3 (i.e. How much 3 is fraction of 35 ?) >> >> *Item* *Quantity* *Cumuletive Sum* A 2 5.71% B 3 C 4 D 5 E 6 >> F 7 G 8 35 >> Waiting for reply-- >> >> Ramkesh >> 9990260398 >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 -- ---------------------------------------------------------------------------------- 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
