Just a thought, if you had another column that added up the information in
columns C-N and you could use your current formula and access the "new"
column of numbers...

--
Wag more, bark less


"Caroline" wrote:

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