View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kane Kane is offline
external usenet poster
 
Posts: 14
Default How format SUMIF formula for matching date range and column value?

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)