Adding values that fall between 2 dates

  • Thread starter Thread starter Dwells
  • Start date Start date
D

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
 
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.
 
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
 
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)
 
Back
Top