Date Range Specific Criteria

March 5, 2009 by vba excel
Filed under: Excel Date Functions 
Sponsor

Excel Date Functions Question:

Ive an issue with excel date functions, i have created the date function SUMIF(A2:A25,”1/10/05″,D2:D25) where the entries of the A column are dates and the D column are amounts. For every entry on 1/10/05, it totals the amount. How can I apply this function with a date
range criteria of one month instead of just one day?

Excel Date Functions Answer:

To apply the excel date functions with your specific date range criteria, use this function:

=SUMPRODUCT(–(TEXT(A2:A25,”yyyymmm”)=”2005Jan”),D2:D25)

  • Digg
  • Sphinn
  • del.icio.us
  • Facebook
  • Google
  • E-mail this story to a friend!
  • Live
  • MisterWong
  • Propeller
  • StumbleUpon
  • Technorati
  • TwitThis
  • YahooMyWeb
  • Print this article!

Rate This Tips:

1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading ... Loading ...


Incoming excel search terms

excel date range,excel criteria date range,date range in excel,excel function date range,date range criteria,date range excel,date range formula in excel,date ranges in excel,excel date range function,excel sumif date criteria,ms excel month function range,,create date range in excel,date range excel function,date range function in excel,excel date criteria,excel date in range,excel date range functions,excel date ranges,excel formula date range,creating date ranges in excel,date functions in excel criteria ranges,date range as criteria,date range criteria excel,date range formula excel,date range function excel,date ranges excel cell,daterange function in excel,excel apply function to range,excel average date range,excel calculate date range,excel compute date,excel criteria range,excel criteria range of dates,excel database functions date criteria,excel function with date range,excel if function date range,excel specific date range,formula functions with specific criteria,vba excel criteria date,0,2h,5,add date range excel,average by date excel,average by date range excel,average by date range in excel,average date range worksheet,average in date range function excel,average of date range excel



Related Excel Tips

Tags: , , , , , , ,

Comments

2 Comments on Date Range Specific Criteria

  1. Kurt Nguyen on Tue, 2nd Jun 2009 3:15 pm

    2. Help on date range. What I’m looking for specifically is to enter a formula in one cell that will read the date off another cell and calculate the last day of that given month. Could someone please help with this formula? I am using MS Excell 2003.

  2. john nowell on Thu, 24th Sep 2009 9:26 pm

    3. have several worksheets which are actually statements of income and would like to find each statement by its date which is basicly the only way of finding different statements. these statements were scanned in with an ocr program.

Have another excel answer or questions for this problem ?
Feel free to post it here..