Using Dates to find value

[Frick]

I am working with two sheets. In sheet 1 I have values based on a months.
On sheet 2, I want to be able to enter a year and have a formula that
returns the value that is the sum of all the months in that year.

For example:

Sheet 1
D3 = 1/1/05 E3= 2/1/05 and so on
D4= 1/31/05 E4=2/27/05 and so on

D10 through BZ110=Monthly values

Sheet 2
D3 = I enter the year, for example 1/1/07
D4 = Formula returns end of year based on D3

Col's E throuh Z are formulas based on D3 returning following years.

So, what I need is a formula that when I enter the date on Sheet2 D3 that
all cells from D10 through Z10, retun a value that sums all the months in
Sheet1 that corresponds to the year entered.

Thanks for all help.

 

[Frank Kabel]

Hi
not completly sure but try
=SUMPRODUCT(--(YEAR('sheet1'!D3:Z3)=YEAR(D3)),D10:Z10)