+ Reply to Thread
Results 1 to 13 of 13

How can I get the average percentage of the GPA less than 3.00?

  1. 02-16-2021, 01:36 PM #1
    excelIsStressingMe
    excelIsStressingMe is offline
    Registered User
    Join Date
    02-16-2021
    Location
    Toronto, Canada
    MS-Off Ver
    2018
    Posts
    6

    How can I get the average percentage of the GPA less than 3.00?

    I've been struggling with this for quite some time (hours) and I keep failing at it. I want to find the average percentage for students who have a GPA less than 3.00.

    Here's an example of my table

    GPA Success Rate
    2.56 50%
    3.95 83%
    2.14 29%
    4.00 100%
    2.01 43%
    3.08 67%

    I'm trying to take the GPA of students with less than a 3.00 and find their average all together.

    For example the success rate for students under 3.00 should be, 40.67%

    Please help me, I keep struggling with this.

    Thank you in advance.
    Reply With QuoteRegister To Reply
  2. 02-16-2021, 01:41 PM #2
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,114

    Re: How can I get the average percentage of the GPA less than 3.00?

    averageif()
    but taking averages of % can be an issue

    =AVERAGEIF(A2:A7,"<"&3,B2:B7)
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
    Reply With QuoteRegister To Reply
  3. 02-16-2021, 01:44 PM #3
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,759

    Re: How can I get the average percentage of the GPA less than 3.00?

    Welcome to the forum.

    Try this:

    =AVERAGE(IF($A$1:$A$6<3,$B$1:$B$6))

    **Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  4. 02-16-2021, 03:16 PM #4
    excelIsStressingMe
    excelIsStressingMe is offline
    Registered User
    Join Date
    02-16-2021
    Location
    Toronto, Canada
    MS-Off Ver
    2018
    Posts
    6

    Re: How can I get the average percentage of the GPA less than 3.00?

    Thank you so much. Thank you thank you thank youths means so much to me.
    Reply With QuoteRegister To Reply
  5. 02-16-2021, 03:33 PM #5
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,114

    Re: How can I get the average percentage of the GPA less than 3.00?

    you are welcome
    Reply With QuoteRegister To Reply
  6. 02-16-2021, 03:51 PM #6
    excelIsStressingMe
    excelIsStressingMe is offline
    Registered User
    Join Date
    02-16-2021
    Location
    Toronto, Canada
    MS-Off Ver
    2018
    Posts
    6

    Re: How can I get the average percentage of the GPA less than 3.00?

    Out of curiosity, if I wanted to do this with an IF(AND function with the ranges between 3 and 4 would it be like, =AVERAGE(IF(AND($A$1:$A$6>33,$A$1:$A$1:$A$6<4),$B$1:$B$6))) ?

    Thank you in advance
    Reply With QuoteRegister To Reply
  7. 02-16-2021, 04:19 PM #7
    excelIsStressingMe
    excelIsStressingMe is offline
    Registered User
    Join Date
    02-16-2021
    Location
    Toronto, Canada
    MS-Off Ver
    2018
    Posts
    6

    Re: How can I get the average percentage of the GPA less than 3.00?

    Quick question, for the criteria in the average function, if I were to want to get the average of a range lets say numbers greater than three but less than 4 (decimals I mean) would it be =averageif(A2:A7, ">3"&"<4", B2:B7)
    Reply With QuoteRegister To Reply
  8. 02-16-2021, 05:08 PM #8
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,114

    Re: How can I get the average percentage of the GPA less than 3.00?

    =averageifS(A2:A7, B2:B7,">"&3", B2:B7 "<"&4)
    But greater than 3 would be 4 and less than 4 would be 3 - ignoring fractions
    so may not give the result you want

    Also you have the Mac excel version 2018 - not sure if it supports averageifs
    Reply With QuoteRegister To Reply
  9. 02-16-2021, 06:03 PM #9
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,759

    Re: How can I get the average percentage of the GPA less than 3.00?

    Try this:

    =AVERAGE(IF($A$1:$A$6>=3,IF($A$1:$A$6<=4,$B$1:$B$6)))

    **Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
    Reply With QuoteRegister To Reply
  10. 02-16-2021, 09:06 PM #10
    excelIsStressingMe
    excelIsStressingMe is offline
    Registered User
    Join Date
    02-16-2021
    Location
    Toronto, Canada
    MS-Off Ver
    2018
    Posts
    6

    Re: How can I get the average percentage of the GPA less than 3.00?

    Thank you so much. You're a life saver!
    Reply With QuoteRegister To Reply
  11. 02-16-2021, 09:07 PM #11
    excelIsStressingMe
    excelIsStressingMe is offline
    Registered User
    Join Date
    02-16-2021
    Location
    Toronto, Canada
    MS-Off Ver
    2018
    Posts
    6

    Re: How can I get the average percentage of the GPA less than 3.00?

    Thank you so much. Excel on Mac 2018 does support it. Thank you again. Thank you so much!
    Reply With QuoteRegister To Reply
  12. 02-17-2021, 03:26 AM #12
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2504 (Windows 11 Home 24H2 64-bit)
    Posts
    90,759

    Re: How can I get the average percentage of the GPA less than 3.00?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

    AVERAGEIFS is supported from Excel 2019 Mac: https://support.microsoft.com/en-us/...8-f7c5c3001690
    Reply With QuoteRegister To Reply
  13. 02-17-2021, 04:21 AM #13
    etaf
    etaf is offline
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.92 (24120731))
    Posts
    9,114

    Re: How can I get the average percentage of the GPA less than 3.00?

    you are welcome
    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. Query regarding Calculating Weighted average value or average value in Percentage.
    By adamsmith1337 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-03-2016, 07:56 AM
  2. [SOLVED] Average Percentage (weighted average) but I want to exclude N/A
    By mespinoza in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 12-28-2015, 02:53 PM
  3. [SOLVED] Average MTD percentage
    By Mike Punko in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 12:05 PM
  4. Average MTD percentage
    By Mike Punko in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  5. Average MTD percentage
    By David Billigmeier in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-06-2005, 07:05 AM
  6. [SOLVED] Average MTD percentage
    By Mike Punko in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 01:05 AM
  7. Average MTD percentage
    By Mike Punko in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-12-2005, 12:05 PM

Tags for this Thread

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