With the query 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:

Hello,
I am trying to get Excel to add data in column "M" if the data in column "A"
is between 8/1/2009 & 8/8/2009. Can anyone help with this formula? Thanks in
advance!