Forum Discussion
Solved
Macro to sumifs a range of values based on dates
I would like to translate the following excel formula to a macro for the sumifs of values based on dates. Currently I am getting an error msg pop up "Run time error 13 Type mismatch" Excel fo...
You have to concatenate with the variable prevdate, and double the quotes in the string.
.Formula = "=SUMIFS(B:B,A:A,"">=""&DATE(YEAR(" & prevdate & "),MONTH(" & prevdate & "),1),A:A,""<=""&EOMONTH(" & prevdate & ",0))"
You're trying to use an Excel formula as VBA code. That won't work. You also forgot the End If belonging to the If ... Then.
If DestwsP.Range("D" & i).Value > DateSerial(Year(Date), Month(Date) - 1, 1) Then
thanks for the help!!