I am trying to open a network workbook and sum the values from column I that
match todays month and year from column A into another local workbook. I
have verified the data and the answer should be 2 but the answer comes back 0.

=SUM(IF((MONTH('\\site\[workbook.xls]worksheet'!$A$4:$A$1000)=MONTH($A$2))*(YEAR('\\sit e\[workbook.xls]worksheet'!$A$4:$A$1000)=YEAR($A$2)),'\\site\[workbook.xls]worksheet'!$I$4:$I$1000))

I seem to remember using the { } around the formula once before for a
situation like this but when I do it just shows the formula in the cell. Any
help?