Hello,

I have exported a table from Access for repairs on various types of
equipment.  I want to calculate the reapirs for each unit (each has a
specific unit number) for each year of its existance.There are three
columns: ReapirDate, UnitNumber, Cost.  I have named these three
ranges.  I have created a second worksheet and have to boxes that the
user can fill in to narrow the search for a particular year (A2) and
unit number (A3).  What I want to do is sum the repairs for that unit
and year.  Here's what I did:

=SUMPRODUCT((YEAR(RepairDate)=A2)*(UnitNumber=A3)*Cost)

But this always returns a value of zero even when I know it's not
zero.  My UnitNumber field was a "text" field in Access because some
of the units have a letter behind them (ie) 75A.  However, I was
hoping to create something as there are over 15000 records.  I have
absolutely no clue how to build a pivot table so I was hoping to
create something with a worksheet function.  Any help/suggestions
would be greatly appreciated.

Thanks in Advance,

Joe