change the formula...
ActiveCell.Formula = "=SUMIFS(D3:D20,$C$3:$C$20,"">""&EOMONTH(MAX(D3:D20),-1))"
sees on the right hand side of the = sign the two string literals
"SUMIFS(D$3:D$200,$C$3:$C$20,"
and
"&EOMONTH(MAX($D$3:$D$20),-1))"
with the > comparison operator between the
Hi All,
I am trying to run the below macro code in the attached file.
Code is running properly since i am not getting any error message.
But i am getting in Row D2 to H2 "TRUE" and not the calculation value.
Option Explicit
Sub SumifsFormula()
'
' SumifsFormula Macro
' Sumifs Formula for calcula
