+ Reply to Thread
Results 1 to 6 of 6

Calculate total rating / ranking

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    15

    Calculate total rating / ranking

    Hi guys

    I'm in need of some help,for the life of me I can't figure this out

    I have a sheet which I will basically fill with some sports data... you can see in the sheet,cells f5 to f22 have the ability for me to apply a star or no star to those cells..its the same for cell columns J,O,S,T,U and V..then in cell AA5 I want to show the total number of stars calcuted bases on cells mentioned previously..so the most it can say is 7 and the least is zero.. You can pull down stars and apply them in the darker blue cells only...

    Can anyone help me with the formula..

    Ive attached my sheet which may make it clearer to understand

    Thanks
    Steve
    Attached Files Attached Files

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,778

    Re: Calculate total rating / ranking

    In AA5 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  3. #3
    Registered User
    Join Date
    03-21-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Calculate total rating / ranking

    Quote Originally Posted by BadlySpelledBuoy View Post
    In AA5 and copy down:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB
    That sir was a mighty fast reply and worked a charm...

    Thanks for helping me out..much appreciated.

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,778

    Re: Calculate total rating / ranking

    Happy to help.

    You could also use:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    BSB

  5. #5
    Registered User
    Join Date
    01-08-2014
    Location
    Missouri
    MS-Off Ver
    365
    Posts
    87

    Re: Calculate total rating / ranking

    Steve,

    FYI. In case you decide to add or use another symbol to mean something else.

    For the star symbol, you've used ASCII Character 221 in Wingdings font...

    You can test that by using this formula:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Last edited by eibi; 03-14-2016 at 04:39 PM.

  6. #6
    Registered User
    Join Date
    03-21-2013
    Location
    Ireland
    MS-Off Ver
    Excel 2007
    Posts
    15

    Re: Calculate total rating / ranking

    Quote Originally Posted by eibi View Post
    Steve,

    You're using ASCII Character 221 as your symbol in Wingdings font...

    So you need this code in Cell AA5:
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Drag to fill.
    Thanks eibi..all good now

+ 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. Need to calculate 5 star reviews for given rating in excel
    By aism in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-05-2014, 04:05 PM
  2. [SOLVED] Calculate rating based on cut point table
    By som3on3_10 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-13-2014, 04:39 AM
  3. TOTAL RATING (out of 100)
    By jantonio in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-24-2013, 11:08 AM
  4. [SOLVED] Rating Total
    By bewise in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-08-2013, 02:23 PM
  5. Excel 2007 : Calculate a Rating
    By Deap in forum Excel General
    Replies: 4
    Last Post: 01-22-2011, 06:15 PM
  6. Ranking by Rating
    By Mike2020 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-31-2007, 07:04 PM
  7. Calculate Rating
    By Peterke in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-03-2005, 03: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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1