# Calculate total rating / ranking

1. ## 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

2. ## Re: Calculate total rating / ranking

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

BSB

3. ## Re: Calculate total rating / ranking

In AA5 and copy down:
Formula:
`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. ## Re: Calculate total rating / ranking

Happy to help.

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

BSB

5. ## 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:
`Please Login or Register  to view this content.`

6. ## Re: Calculate total rating / ranking

Originally Posted by eibi
Steve,

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

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

Drag to fill.
Thanks eibi..all good now

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