ScottHope:Kat, as shown in the above formula I have used a table instead of a named range. The reason I have done this is because when I add more data to the bottom of the table it automatically increases the table size to incorporate the new data, when I used a named range that didn't happen.
Seems like with anything electronic, there has to be a "work-around". It seems like if you were to add one additional row to the named range (at the bottom), then inserted an entire row, the named range would grow.
For example, say you start off with 1 score, on row 3. You define your range E3:E4. In cell location A4, you enter the text "Insert new row here" (or leave it blank and remember to do an insert row). The "Count" function will only count cells with numbers, so it's going to return 1. Now, when you insert the row, the range should change from E3:E4 to E3:E5.
Since I'm not really well versed in Excel (I'd rather write a macro to handle complex calculations than write a complex formula), I'm not sure how the table function works ... if it automatically resizes, I'd define a table as you suggest.