Thread: How format SUMIF formula for matching date range and column value?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
  
Posts: 3,718
Default How format SUMIF formula for matching date range and column value?
=SUMPRODUCT(--(RngF="groceries"),--(RngDate=DATE(2010,2,1)),--(RngDate<=DATE(2010,2,8)),RngD)


"Kane" wrote:

Here is my current SUMIF formula. How would I modify this to add the
selection of a date range from the same data columns? Example, start date of
2/1 and end date of 2/8.

=SUMIF(Jan!$F$9:$F$55202,"groceries",Jan!$D$9:$D$5 5202)


Reply With QuoteReply With Quote