hi all

Hope someone can help! I'm using these 2 formulas:-

=-(SUMPRODUCT(('Actuals YTD'!$A$2:$A$630=3014111)*('Actuals
YTD'!$A$2:$A$630<=3639991)*('Actuals YTD'!$C$2:$N$630)))

and

=+SUMIF('Budget YTD'!$A$2:$A$630,"=5200111",'Budget YTD'!$C$2:$N$630)

The problem I'm having is that where i want to pick up the sum of columns C
to N, it won't work. If i want just column C then it works perfectly, but it
won't add up more than one column. (The C to N columns are labelled from
April to March, and I want to produce year to date figures for the particular
codes.)

I hope that makes some kind of sense!

Thanks in advance for your help
Caroline