average scores a 'name'

Can someone simplify this formula so I would not need to press and hold Ctrl+Shift then press Enter so that the formula works. I use a Excel 2003

Formula is:

=SUM(IF(Range1=A1,if(Range2=A2,Score)))/SUMPRODUCT((Range1=A1)*(Range2=A2))

Range1 = a range name for varying dates
Range2 = a range name for varying names
Score = a range name for Corresponding Scores
A1 = a date
A2 = a name

Purpose of the above formula is to get the average scores a 'name' has acquired at a given 'date.'