Thread: SUMPRODUCT Between Dates
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default SUMPRODUCT Between Dates
On Tue, 20 Jan 2009 07:37:15 -0800, JerryS <Jerry B
wrote:

I'm looking for a formula that will add the total number of units in one
column that fall between dates of another column. Dates are shown as
01/01/2009 for example and I am looking to sum units between 01/01/2009 and
01/31/2009. Thanks

A1: 01/01/2009
A2: 01/31/2009

dates: your range of cells containing the dates (e.g. B1:B1000)
units: your range of cells containing the numbers of units (e.g. C1:C1000)

=SUMIF(dates,"="&A1,units) - SUMIF(dates,""&A2,units)
--ron
Reply With QuoteReply With Quote