N

Try SUMPRODUCT

=SUMPRODUCT(--(YEAR(MyDateRange)=2008), MyAmountRange)

Substitute in your ranges as appropriate.

Mike

"N" wrote:

I'm trying to calculate the totals based on years and don't want to do a
basic sum in case I move things around, I want the totals to be specifically
based on the year.

I have appx 50 rows of data and need the formula to find all dates for the
specific year and then sum those corresponding totals.

Both columns are named as Amount and Finish_Date and E is formatted as a
date, not text. I've tried several formulas and just can't get it to give me
a total or the correct one. What am I missing?

Thank you!

Column D Column E
Amount Finish Date
$45,000,000 Mar-02
$50,000,000 May-05