You would need to use SUMPRODUCT since you're testing an array of dates for
the year:

=SUMPRODUCT(--(YEAR(INDIRECT("'"&A3&"'!E8:E71"))=2005),INDIRECT( "'"&A3&"'!D8:D71"))

--
Biff
Microsoft Excel MVP


"LongTermNoob" wrote in message
...
Thanks for the info Carim, but it's still returning 0. This is the actual
formula, rather than an example:

=SUMIF(INDIRECT("'"&A3&"'!E8:E71"),"2005",INDIRECT ("'"&A3&"'!D8:D71"))

When I evaluate the formula it appears to be looking in all the right
places.

The date format in E8:E71 is dd-mmm-yy in case that makes a difference.


"Carim" wrote:

Hi,

The issue is with "*05" ... "2005" works fine ..

HTH