Adding values that fall between 2 dates

[Dwells]

i'm using this to add values that are between 2 date
=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

 

[Mike H]

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.

 

[Pete_UK]

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

 

[T. Valko]

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)