SUMIFS problem

[will31]

Hi All,


I have the following formula which doesn't work;


=SUMIFS(Data!$G$2:$G$3000,Data!$A$2:$A$3000,CTS!$A40,Data!$F$2:$F$3000,"=>"&CTS!I$2,Data!$F$2:$F$3000,"<"&CTS!J$2)


Data!G2:G3000 is a list of prices

Data!A2:A3000 is a list of project numbers

Data!F2:F3000 is a list of dates where project events take place


I need to sum based on a match for the project number is CTS!A40 AND the date being more than CTS!I2 and less than CTS!J2. I can't understand why the formula doesn't work. Any ideas?

 

[Kevin Lehrbass]

Hi Will31,


I think the only issue is "=>" versus ">="

Try moving the = sign after the > sign. It's working on my sample file I made.


=SUMIFS(Data!$G$2:$G$3000,Data!$A$2:$A$3000,CTS!$A40,Data!$F$2:$F$3000,">="&CTS!I$2,Data!$F$2:$F$3000,"<"&CTS!J$2)


Cheers,

Kevin

 

[will31]

Thanks Kevin, worked perfectly!