Date Range

  • Thread starter Thread starter JeffK
  • Start date Start date
J

JeffK

I have a list of Sales (column A) and a list of closing dates (Column B). On
a separate sheet, I have a summary page showing total sales closing within
30day,then 60days then 90days.

I was going to use the Sumif functions =sumif(B1:B1000, criteria, A1:A1000)
but I can't figure out the criteria formula for each of the 3 periods.
 
Use something like this:

=SUMIF(B1:B1000,"<="&TODAY()+30,A1:A1000) - SUMIF(B1:B1000,"<"&TODAY
(),A1:A1000)

The first term sums all the sales up to 30 days away, and the second
term (subtracted from this) is all the sales before today.

Just change the 30 to 60 or 90 for your other date ranges.

Hope this helps.

Pete
 
Suppose your summary sheet has got Start date and end date and in ColC you
need the totoal between..try the below formula
Col A Col B Col C
8/21/2009 8/23/2009 =

=SUMPRODUCT(--(Sheet1!B1:B1000>=A1),--(Sheet1!B1:B1000<=B1),Sheet1!A1:A1000)

Sheet1 cols A and B contains the data

If this post helps click Yes
 
Back
Top