Closed Thread
Results 1 to 2 of 2

Formula for Convert Variance to a Percentage Using SUMPRODUCT

  1. #1
    Forum Contributor
    Join Date
    06-21-2010
    Location
    -
    MS-Off Ver
    Excel 2010
    Posts
    1,211

    Formula for Convert Variance to a Percentage Using SUMPRODUCT

    Please accept my apologies, I'm unsure what the forum policy is when you've posted a question but not been able to find a solution, so this is a repost of this problem. The original can be found here:

    http://www.excelforum.com/excel-form...umproduct.html

    Basically nflsales came up with a really neat SUMPRODUCT MMULT formula to solve a problem (see link above)

    Please Login or Register  to view this content.
    and now I need to adjust this formula to allow me to display the variance as a percentage. See column AA in the attached, this gives me the variance based on the current month as defined by the SUM of the total actual column equalling zero, but for the life of me I can not figure out how to convert this into a percentage.

    I wondered if any geniuses out there could assist as I've been trying to figure this out for days and am no closer... The expected results appear in column AD, but need to use an adaptation of nflsales's SUMPRODUCT to obtain the result.

    Many thanks in advance for any help.
    Attached Files Attached Files

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    16,906

    Re: Formula for Convert Variance to a Percentage Using SUMPRODUCT

    Quote Originally Posted by HangMan View Post
    Please accept my apologies, I'm unsure what the forum policy is when you've posted a question but not been able to find a solution, so this is a repost of this problem.
    The policy is that duplicate threads are not allowed. I'd suggest, as a seasoned member, that you take the time to review our rules. There aren't many, and they are all important.

    If you have not received an answer in a reasonable amount of time (~1 day) then it's acceptable to bump your thread by adding another post.

    This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

    Thread Closed.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Convert Variance to a Percentage Using SUMPRODUCT
    By HangMan in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 06-01-2015, 02:33 PM
  2. Percentage Variance Graphs
    By Bobo6782 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 03-04-2014, 07:00 AM
  3. How do I obtain a variance percentage? Please check my calculation/formula
    By Dixiewest in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 10-12-2013, 02:58 PM
  4. Replies: 1
    Last Post: 04-16-2013, 03:58 PM
  5. Conditional Formatting using Percentage Variance
    By Skarnald in forum Excel General
    Replies: 3
    Last Post: 02-09-2012, 11:03 PM

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