I am using the Excel Conditional Sum Add In to generate the following formula:
{=SUM(IF(Costs!$A$2:$A$5000=2010,IF(Costs!$D$2:$D$5000="Executive Management",Costs!$F$2:$F$5000,0),0))}
What I am trying to do is have a cell that sums the monthly cost of all entries in my cost sheet labelled "Costs" which have the following characteristics: "2010" and "Executive Management".
This works fine when I use the wizard to generate the above formula. The problem arises when I copy this formula to another cell and then change one of the characteristics manual (e.g "2010" to "2011")..then the formula doesn't return anything.
Do I need to refresh the sheet or something. What am I doing wrong?
{=SUM(IF(Costs!$A$2:$A$5000=2010,IF(Costs!$D$2:$D$5000="Executive Management",Costs!$F$2:$F$5000,0),0))}
What I am trying to do is have a cell that sums the monthly cost of all entries in my cost sheet labelled "Costs" which have the following characteristics: "2010" and "Executive Management".
This works fine when I use the wizard to generate the above formula. The problem arises when I copy this formula to another cell and then change one of the characteristics manual (e.g "2010" to "2011")..then the formula doesn't return anything.
Do I need to refresh the sheet or something. What am I doing wrong?
