Excell sumifs

SUMIFS(A27:A36,C27:C36,TEXT(TODAY(),"MMM") I have one column with "dollar value", another column with calculated month, "format mmm", "Jan". The calculated month comes from a calculated cell, "format...