Harmeet Singh 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
>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 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&
