+ Reply to Thread
Results 1 to 2 of 2

Formula needed: Averages per user based on text contained in another cell

  1. #1
    Registered User
    Join Date
    04-06-2020
    Location
    Pennsylvania, United States
    MS-Off Ver
    Excel 2013
    Posts
    1

    Formula needed: Averages per user based on text contained in another cell

    Hi,
    I am in need of a formula (or other suggestion/idea) on how to calculate averages for each user based on whether or not they have grades in part A and part B of the same class. For example, if user 1 is in English 10 A and English 10 B, they should have grades for both of these sections. I need to avereage those 2 grades for one final English 10 grade.

    The difficulty is that there are 4000+ users with a large variety of courses.

    Some of these courses do not have part A & part B. Those classes can be ignored as their current grade is the average for that class.
    I have attached an small example of what my current pivot table looks like for each user.
    I am open to any ideas or suggestions you may have.
    Please let me know if you need further information.
    Thank you for your time!
    Attached Files Attached Files

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,186

    Re: Formula needed: Averages per user based on text contained in another cell

    I am unable to open your file (at work), but take a look at using AVERAGEIFS for this?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ 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. Replies: 2
    Last Post: 09-04-2019, 11:22 AM
  2. Highlight cells based on text contained in another Sheet
    By hummer123 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-11-2016, 04:57 AM
  3. [SOLVED] Looking for a formula that indicates text not contained in a list.
    By Travisty in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 10-20-2015, 09:58 AM
  4. [SOLVED] Formula needed to get Date in text based on numbers
    By caabdul in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-25-2014, 08:40 PM
  5. [SOLVED] Can not figure out how to color cells based on the text contained in the cell
    By Kjorg in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2012, 07:00 PM
  6. Categorising rows of data based on the text contained
    By foxyfmu in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-28-2012, 07:15 AM
  7. Formula using text contained in a cell as criteria
    By Darik777 in forum Excel General
    Replies: 3
    Last Post: 10-20-2010, 10:03 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