+ Reply to Thread
Results 1 to 4 of 4

Calculating a Percentage of a Percentage

  1. #1
    Registered User
    Join Date
    02-24-2010
    Location
    Edmond, OK
    MS-Off Ver
    Mac Numbers and Mac Excel Ver 16.22
    Posts
    95

    Calculating a Percentage of a Percentage

    I have been wracking my brain for several hours here and so I thought I would throw this one out there to see if someone smarter than me can figure this out. I don't know if this is more of a math problem or excel formula/VBA code issue. I believe I am looking for a weighted average formula. Any feedback would be appreciated! This is definitely not an easy one!


    http://screencast.com/t/aribqlz3csog

    Thank you,

    Tim

    Pedry_Overhead and Estimating Ver.2.6.xlsm
    Last edited by tpedry; 01-26-2014 at 04:26 PM.

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,147

    Re: Calculating a Percentage of a Percentage

    HAve you tried in M7 something like:
    =IFERROR(SUM(H7*F7)/$F$48,"")

  3. #3
    Registered User
    Join Date
    02-24-2010
    Location
    Edmond, OK
    MS-Off Ver
    Mac Numbers and Mac Excel Ver 16.22
    Posts
    95

    Re: Calculating a Percentage of a Percentage

    Yes, It is definitely not that simple. Wish it was.........

  4. #4
    Registered User
    Join Date
    02-24-2010
    Location
    Edmond, OK
    MS-Off Ver
    Mac Numbers and Mac Excel Ver 16.22
    Posts
    95

    Re: Calculating a Percentage of a Percentage

    This did the trick......


    =IFERROR(IF(F7<>"",(SUMPRODUCT(H7:H46,F7:F46)/F$48),""),"")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. calculating percentage of percentage
    By zinneken in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 10-10-2013, 10:12 AM
  2. Replies: 1
    Last Post: 01-13-2013, 08:39 PM
  3. Calculating a percentage with the end percentage in mind
    By Shadowshady in forum Excel General
    Replies: 2
    Last Post: 06-17-2006, 04:45 AM
  4. Replies: 2
    Last Post: 02-01-2006, 12:50 PM
  5. Calculating Percentage
    By mconnolly in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM

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