using sum(if function
 

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?

using sum(if function
 

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


--

Regards,

Peo Sjoblom


"Scott" wrote in message
...
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?

using sum(if function
 

Hi

Try this:
=SUMPRODUCT((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))

Andy


"Scott" wrote in message
...
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?