+ Reply to Thread
Results 1 to 4 of 4

Calculating a Percentage of a Percentage

  1. 01-26-2014, 05:44 AM #1
    tpedry
    tpedry is offline
    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.
    Reply With QuoteRegister To Reply
  2. 01-26-2014, 06:15 AM #2
    Kaper
    Kaper is offline
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,613

    Re: Calculating a Percentage of a Percentage

    HAve you tried in M7 something like:
    =IFERROR(SUM(H7*F7)/$F$48,"")
    Reply With QuoteRegister To Reply
  3. 01-26-2014, 09:59 AM #3
    tpedry
    tpedry is offline
    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.........
    Reply With QuoteRegister To Reply
  4. 01-27-2014, 03:44 PM #4
    tpedry
    tpedry is offline
    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 With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. increasing a range of cells by a percentage but need to add the percentage on to original
    By lammie26 in forum Excel Formulas & Functions
    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. [SOLVED] Format-Can a cell that is formated for percentage be red if the percentage is negativ
    By SteveW in forum Excel General
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1