Hi,

Simply use cell references for the dates

=SUMPRODUCT(--(G8:G26=A1),--(G8:G26<=A2),F8:F26)
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.


"Dwells" wrote:

i'm using this to add values that are between 2 dates
=SUMPRODUCT(--(G8:G26=DATEVALUE("1/1/2010")),--(G8:G26<=DATEVALUE("1/30/2010")),F8:F26)

but i need the dates 1/1/2010 and 1/30/2010 to be user input. so that those
values are reading from another cell. is this possible