Sum column based on date

[goldcat]

Hi all,

For this I am only worried about two columns E(date) & F(amount).

What I need to do do is sum the values in column F that are before today which I have placed in A1. I thought I could use a sumif but I can not workout the arguments to use.

 

[jbeaucaire]

Maybe this:

=SUMPRODUCT(--(E2:E200 < A1), F2:F200)

...or this:

=SUMIF(E2:E200, "<"&A1, F2:F200)

 

[stanleydgromjr]

goldcat,

Excel Workbook
	A	B	C	D	E	F
1	3/22/2009	6600			Date	Amount
2					3/1/2009	100
3					3/3/2009	200
4					3/5/2009	300
5					3/7/2009	400
6					3/9/2009	500
7					3/11/2009	600
8					3/13/2009	700
9					3/15/2009	800
10					3/17/2009	900
11					3/19/2009	1000
12					3/21/2009	1100
13					3/23/2009	1200
14					3/25/2009	1300
15					3/27/2009	1400
Sheet1

Have a great day,
Stan

 

[goldcat]

Thanks for the quick replies I ended up using

=SUMIF(E2:E200, "<"&A1, F2:F200)

It worked as I knew it should ... I would have never thought of using the ("<"&) combination