I suggest you use C1 to put the date you are interested in, and then
in D1 you can have ths formula:

=SUMIF(A:A,C1,B:B)

This way your data can be as long as you like in columns A and B.

Hope this helps.

Pete

On Aug 13, 8:06*pm, lexmarcos
wrote:
I want to sum B1, with date *(constant e.g. DATEVALUE ("1/1/09"), no start
and end) IN A1. Any advice is appreciated.

AB
1 1/1/09 10
2 1/2/09 20
3 1/1/09 10
4 1/3/09 15
5

If i can find a way to sum and return values *in A5 to equal 20 (1/1/09 is
10 + 10)

Thanks.



"Jacob Skaria" wrote:
With the start and end dates in C1 and D1 ;try the below formula

=SUMPRODUCT(--(A1:A100=C1),--(A1:A100<=D1),M1:M100)

If this post helps click Yes
---------------
Jacob Skaria

"Dhardy" wrote:

I am trying to have Excel sum data in column “M” if data in column “A” is a
certain date range. Any tips/advice?- Hide quoted text -

- Show quoted text -