+ Reply to Thread
Results 1 to 3 of 3

Please Help with percentages!!

  1. #1
    Registered User
    Join Date
    10-01-2011
    Location
    Belgrade
    MS-Off Ver
    Excel 2007
    Posts
    1

    Please Help with percentages!!

    I need big help guys, i have attached a jpg file in this post, as you can see there are two data sets, first with numbers and second in percents. If somebody could please tell me how can i automatically calculate and autofill the percentages from the first set into second , does somebody know the way or formula?
    Big tnx in advance

    http://imageshack.us/photo/my-images/839/unledspu.jpg/
    Attached Files Attached Files
    Last edited by cashman; 10-01-2011 at 03:23 PM.

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Please Help with percentages!!

    Please post a sample sheet instead of a picture - Thx

  3. #3
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Please Help with percentages!!

    In C11 and copy down and across,


    =IF(SUM(C$5:C$7), C5/SUM(C$5:C$7), "")
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1