If you put the start date in A1 and the end date in B1 (both in Excel
date format), then you can have:

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

Hope this helps.

Pete

On Feb 23, 6:48*pm, 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/20*10")),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