Hey everyone, I really need someone to help me out with a formula.
I've got 3 columns, Product, Date, and Dollar Amount. This sheet is
tracking everything since 2007 and it's going to end up running well
into the future. What I need is a formula that will provide me the
dollar amount spent on a product in a given year. I've tried
variations of a =sumif(and formula, but have been unable to get
anything even remotely resembling a formula that's functional. I
really hope I've explained this well enough. Here's a small example
of the sheet.


apples LA SH 11/20/2007 $1,464.00
oranges MT LS 12/3/2007 $972.00
cherrys IN OEP SH 1/24/2008 $662.40


Thanks in advance for any help.