Adding values that fall between 2 dates
 

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

Adding values that fall between 2 dates
 

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

Adding values that fall between 2 dates
 

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

Adding values that fall between 2 dates
 

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