Many thanks Biff, it works a treat. I originally got a #VAL error and when I
checked it through found two date fields with "N/A" in them. Could this have
caused the problem with SUMIF, or is it a definite no-go for this type of
evaluation?

Thanks again, and thanks to Carim for trying to help.



"T. Valko" wrote:

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