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
 

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

dynamic chart- curve drops to zero ( Line) 0
Sumif across a table 2
Dynamic chart- curve dropping to zero ( chart type- Line) 0
How to use SUMIF to return sums between two values located in cells 1
Sort Columns in Protected Worksheet, etc. 0
Double Negative Problem 1
Multi-Conditional IF Statements 3
function question (sumif countif conditional) 0

Top