Simplifying a formula

fatboy1973 · #1 02-26-2017, 07:46 AM

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

xor · #2 02-26-2017, 10:04 AM

Can the attached be used?

fatboy1973 · #3 02-26-2017, 10:06 AM

Hi there,

thanks for the reply, it works exactly to what I required,

thanks again

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula	innkeeper9	Excel	2	09-13-2016 08:59 PM
simplifying revision marks / comparing strings	marcelma	Word VBA	0	11-09-2015 11:38 AM
Need help with dragging a formula and changing a reference column as I drag the formula.	LupeB	Excel	1	10-22-2015 03:02 PM
What formula should I use?	streetcat	Excel	2	07-01-2015 11:07 PM
Simplifying the work. (colours)	Anderlfs	Word	8	03-25-2011 02:57 PM