using sum(if function

[Guest]

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('\\site\[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?

 

[Peo Sjoblom]

enter the formula with ctrl + shift & enter and the curly brackets will be
applied automatically

 

[Guest]

Hi

Try this:
=SUMPRODUCT((MONTH('\\site\[workbook.xls]worksheet'!$A$4:$A$1000)=MONTH($A$2))*(YEAR('\\site\[workbook.xls]worksheet'!$A$4:$A$1000)=YEAR($A$2)),--('\\site\[workbook.xls]worksheet'!$I$4:$I$1000))

Andy