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

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))
--
Celia


"Celia" wrote:

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

Excel 2007
Table with formulas
PivotTable without formulas (Value as Column)
http://www.mediafire.com/file/ddquzm...04_07_09a.xlsx