So what do you need instead?

--
__________________________________
HTH

Bob

wrote in message
...
On Jun 24, 3:51 pm, "Bob Phillips" wrote:
=SUMPRODUCT(--(rng_product="SH"),--(YEAR(rng_dates)=2008),rng_Dollars)

--
__________________________________
HTH

Bob

wrote in message

...

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.

Thanks for the reply Bob. However what you proposed won't work. I
should have noticed it when I posted, but the SH & LS are the initials
of the sales person.