Simplifying a formula

[fatboy1973]

Hello all,

Is there a simple version of the formula below with it still able to complete the full range of calculations, ideally looking to have the range that the calculations come from only to be entered once, T.I.A.



=COUNTIF('2017'!$AK$8:$AQ$51,"a")*12.25+COUNTIF('2 017'!$AK$8:$AQ$51,"a11")*11+COUNTIF('2017'!$AK$8:$ AQ$51,"a10")*10+COUNTIF('2017'!$AK$8:$AQ$51,"a9")* 9+COUNTIF('2017'!$AK$8:$AQ$51,"a8")*8+COUNTIF('201 7'!$AK$8:$AQ$51,"a7")*7+COUNTIF('2017'!$AK$8:$AQ$5 1,"a6.25")*6.25+COUNTIF('2017'!$AK$8:$AQ$51,"a6")* 6+COUNTIF('2017'!$AK$8:$AQ$51,"a5")*5+COUNTIF('201 7'!$AK$8:$AQ$51,"a4")*4+COUNTIF('2017'!$AK$8:$AQ$5 1,"a3")*3+COUNTIF('2017'!$AK$8:$AQ$51,"a2")*2+COUN TIF('2017'!$AK$8:$AQ$51,"a1")*1