Hi,

What was your original posting ? Can you post that as well.

Or else stick to your earlier thread to post any comments.

Regards

Govind.

Jules wrote:
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('turno ver'!$A$1:$A$1000,0,MATCH($C8,'turnover'!$B$1:$N$ 1,0)))