Sumproduct and Sumif formulas
 

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

Sumproduct and Sumif formulas
 

Hi,
try

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



"Caroline" wrote:

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

Sumproduct and Sumif formulas
 

Try
=SUMPRODUCT(('Budget YTD'!$A$2:$A$630=5200111)*
('Budget YTD'!$C$2:$N$630))

If this post helps click Yes
---------------
Jacob Skaria


"Caroline" wrote:

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