IF(date>10/29/04,+A2,0)

[shallbetter]

How can I use IF statement to SUM numbers on a list which have related date list.

IF(date>10/29/04,+A2,0)

If I use the above formula it sees the"10/29/04" as a number not a date.

Any help would be greatly appreciated!

Rob Martin

 

[Von Pookie]

Try the SUMIF function:

Book1
	A	B	C	D
1	2	10/29/2004		7
2	3	1/27/2005
3	5	10/29/2004
4	10	1/13/2005
5	4	10/30/2004
Sheet1

 

[shades]

Use SUMIF:

=SUMIF(A:A,">1/29/2005",D:D)

This will check column A and note any dates after the given one, then sum the values in column D.

 

[shallbetter]

Perfect. Thanks.