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 m-d", 1-8. (SUMIFS will not calculate a monthly total based on a caluculated month. I get 0 as a total.