View Single Post
  #6  
Old September 15th, 2020, 03:02 PM
danlee58 danlee58 is offline
Senior Member
 
Join Date: May 2003
Location: DELAWARE
Age: 83
Posts: 177
I got =EDATE(E3, -1) to give me the previous month, but it only wants to use the future dates for summing. Here is my current formula:
=@SUMIFS(D3300,A3:A300,">="&E3,A3:A300,"<="&F3)
Reply With Quote