+ Reply to Thread
Results 1 to 4 of 4

Formula that averages percentages based on said criteria

  1. #1
    Registered User
    Join Date
    07-24-2012
    Location
    burlington WA
    MS-Off Ver
    Excel 2010
    Posts
    54

    Formula that averages percentages based on said criteria

    Hello:
    I need a formula that counts down and averages the percentages in column A and display it in the the highlighted cell. For example: "If cell to the left says SPL then average the percentages down until the next SPL cell only"

    barcode example.xlsx

  2. #2
    Forum Expert tigeravatar's Avatar
    Join Date
    03-25-2011
    Location
    Colorado, USA
    MS-Off Ver
    Excel 2003 - 2013
    Posts
    5,361

    Re: Formula that averages percentages based on said criteria

    Leif Magnus,

    Attached is a modified version of your posted workbook.
    In cell B1 and copied down is this formula:
    Please Login or Register  to view this content.

    If your actual workbook has more than 100 entries, change the red number to be beyond your maximum data (like 1000 or 5000, or whatever is needed). Does that work for you?
    Hope that helps,
    ~tigeravatar

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  3. #3
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,216

    Re: Formula that averages percentages based on said criteria

    One way is to use a helper column, say Column B, this can be hidden with a grouping button
    In B1, Drag/Fill Down
    Formula: copy to clipboard
    Please Login or Register  to view this content.

    Then in C1, Drag/Fill Down
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Attached Files Attached Files
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  4. #4
    Registered User
    Join Date
    07-24-2012
    Location
    burlington WA
    MS-Off Ver
    Excel 2010
    Posts
    54

    Re: Formula that averages percentages based on said criteria

    That worked beautifully. Thank you for the assistance tigeravatar. I love how simple and direct it is!

+ 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