Hi there

I'm trying to get the following fomula to work.

=SUMIF('Actuals YTD'!$A$2:$A$630,"=5010111",'Actuals
YTD'!$C$2:$N$630)+SUMIF('Actuals YTD'!$A$2:$A$630,"=5010211",'Actuals
YTD'!$C$2:$N$630)+SUMIF('Actuals YTD'!$A$2:$A$630,"=5120111", 'Actuals
YTD'!$C$2:$N$630)+SUMIF('Actuals YTD'!$A$2:$A$630,"=5200111",'Actuals
YTD'!$C$2:$N$630)

It doesn't appear to be picking up the figures in any other column other
than "C", when it should be adding up from "C" to "N". A SUMPRODUCT doesn't
work due to the fact the data I'm searching on doesn't run in sequence.

Any help greatly appreciated!!

Thanks
Caroline