I am trying to use the sumif (i think an array) to determine what the total
sales for a period are.
An ex. of my table is:
Col A Colm B Col C Col D
Col E Col F
row 1 total units Unit Price Date Sold
row 2 4 $20 Jan 2010 Feb 2012 Jan
2014 Feb 2014
row 3 2 $5 Jan 2009 Jan 2010
row 4 3 $7 Jan 2010 Feb 1010
March 2011

So I am trying to create the yearly sales as follows

2009 2010 2011 2012 2013 2014
total sales $5 $39 $7 $20 $0 $40

I have excel 2007 and I was using the following formula for year 2010 but it
didn't work - I made the formula an array formula as well.

=SUMIFS(b2:b4,c2:f4,"="&Date(2010,1,1),c2:c4,"<"& Date(2011,1,1))

Why doesn't this work and does anyone have a suggestion on what I should use
instead?

Thanks for much
Celia