C

#### Celia

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

Thanks for much
Celia

C

#### Celia

I realize my formatting got messed up so I am trying again to show my table

Col A Col B Col C Col D Col E Col F
row 1 Units Price Sold
row 2 4 \$20 Jan-10 Feb-12 Jan-14 Feb-14
row 3 2 \$5 Jan-09 Jan-10
Row 4 3 \$7 Jan-10 Feb-10 Mar-11

2009 2010 2011 2012 2013 2014
Sales \$5 \$39 \$7 \$20 \$- \$40

This is what I tried for 2010 as an array formula
=SUMIFS(b2:b4,c2:f4,">="&Date(2010,1,1),c2:c4,"<"&Date(2011,1,1))