Need help. This is really simple and I don't know how to do it. I am trying to calculate a hi point for a horse show. It is two judges each day over two days. A is the horses back number and B is the points that they earned.
I need to consolidate the back number and add the total points that they have earned. Consolidate data does exactly what I need but even though I link to source data it doesn't update from having no back numbers entered, to showing them as I enter back numbers.




This is what I have and this is what I want.

A ........................B
Back # ................. Points Earned
154..........................6
111..........................5
112...........................4
3...............................3
88...........................2
99...........................1

154..........................6
111 .........................5
15............................ 4
88............................. 3
112............................2
99............................1

...............

There would be two more sets of columns and rows below just like this (One set for each judge)


I want it to list the total points earned per horse in a different workbook, sorted by descending
ie

154..... 12
111..... 10
112..... 6
88..... 5
15...... 4
3 ....... 3
99....... 2

This should be simple and I can't get it. Please help!