Hi

Still can't get this formula to work. It is referencing the column no and
bring the data in that column but is not adding the colums up to that column
no. Ir if if C8 = 9 and the value in col 9 is 4211.00, then the formula is
showing 4211 and not the sum of all the columns up to column 9.

Hi
now that helps :-)
try the following formula:
=SUMIF('turnover'!$A$1:$A$1000,$B8,OFFSET('turnov er'!$A$1:$A$1000,0,MATCH($C8,'turnover'!$B$1:$N$1 ,0)))

--
Tx
Jules