# Calculating a Percentage of a Percentage

1. ## 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

2. ## Re: Calculating a Percentage of a Percentage

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

3. ## Re: Calculating a Percentage of a Percentage

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

4. ## Re: Calculating a Percentage of a Percentage

This did the trick......

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

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

#### 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