View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JLR-Mart JLR-Mart is offline
external usenet poster
 
Posts: 24
Default SUMIFS and dates

I have some data and wish to use the sumifs function to add up sums when a
criteria is true and the date is less than a month ago. I have tried using
date-30 to no avail. Any suggestions?