Conditional SumIf


M

Martin Burford

=SUM(IF('Ruth budget.xls'!Activity_code=C6,IF('Actuals
Download'!$G$5:$G$4472=D6,IF('Ruth budget.xls'!CE_Code=E6,'Actuals
Download'!$V$5:$V$4472,0),0),0))

I want to hard code the values in red i.e D6 and E6 and vary the
Activity_code C6, however making them absolute doesn't work. this uses an
excel addin called conditional sumif.

Any ideas???

Many thanks

Martin Burford
 
Ad

Advertisements


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

Top