C
Caroline
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
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