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
instead?
Thanks for much
Celia
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