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