Try:

=SUMPRODUCT((D7:D36=DATE(YEAR(TODAY()),MONTH(TODA Y())-
6,DAY(TODAY())))*(TODAY()=D7:D36)*E7:E36)

HTH
Jason
Atlanta, GA

-----Original Message-----
I have a colum with exact dates and another with values
that correspond to
those dates. Columns D and E respectively. Rows 7-36.
What I would like to do
in another cell is total the values entered in E for the
a date range in D
between today and 6 months prior to todays date.
.