Help with SUMIFS formula

Hi all, I'm new to this forum and wishing if you could help me with this formula.

I'm trying to sum specific amounts based on 3 criteria: project nr. match, minimum and maximum date match, the data are in two different excel files (attached). My formula is resulting in a #VALUE! error and I can't figure out what's wrong

For January, if the project nr. matches, plus the dates between 01/01/2014 and 01/31/2014, inclusive, then sum in column B; for February, if the project nr. matches, plus the dates between 02/01/2014 and 02/28/2014, inclusive, then sum in column C, and so on...

Any help would be highly appreciated, many thanks!

Dri

I prefer SUM.PRODUCT (its compatibile with lower versions of excel)
In workbook forecast in cell B3 formula:

Formula:

Please Login or Register  to view this content.

Try this in B3 on the Forcast Book

=SUMIFS(Projects.xlsx!$B$2:$B$20,Projects.xlsx!$A$2:$A$20,$A3,Projects.xlsx!$C$2:$C$20,">="&B$2,Projects.xlsx!$C$2:$C$20,"<"&EDATE(B$2,1))

Both formulas worked! Thanks a lot for your help!

You're welcome.