Sumproduct and Sumif formulas

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
 
E

Eduardo

Hi,
try

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

Jacob Skaria

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

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top