Calculate ratings probility

Hello All
On the attached worksheet i have groups of data sorted by date,horse place & time.In col W a rating value is given for each horse.To convert these ratings into probility/odds i have done the following
A.In col x calced the sum of the ratings for each group
B.In col y divided each rating by the total for the group.eg in row 2 horse 1 has a 22% probility of winning.
C.In col z divided 1 by each value in col y to convert the value to odds.
Its longwinded, so is it possible to combine these calcs into a single formula to produce the result in col z.
In col w ratings with a blank or 0 are ignored.Values are to 2 dec places
I have also separated the data with empty rows for clarity,there are no empty rows in the data.
Many thanks for help given.

Hi,

One way

Formula:

Please Login or Register  to view this content.

hi there. so in short, you want Column X:Z combined into 1? maybe:
=IF(W2>0,1/(W2/SUMIFS(W:W,E:E,E2,A:A,A2)),"")