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

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

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

Try one of these...

A8 = lower date boundary = 1/1/2010
B8 = upper date boundary = 1/30/2010

=SUMIF(G8:G26,"="&A8,F8:F26)-SUMIF(G8:G26,""&B8,F8:F26)

If you're using Excel 2007:

=SUMIFS(F8:F26,G8:G26,"="&A8,G8:G26,"<="&B8)

--
Biff
Microsoft Excel MVP


"Dwells" wrote in message
...
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