Formula Assistance Utilizing a Table

[jstevens]

I'm having a challenge with a SUMIFS formula. The value being returned is 0, not the intended result.
=SUMIFS(Trans_Amt,Trans_Type,H3,Trans_Date,">="&TEXT(FromDt,"yyyy-mm-dd"),Trans_Date,"<="&TEXT(ToDt,"yyyy-mm-dd"))

I have attached a sample workbook.

el_table_result.xlsx

Thanks for taking a look.

[HansV]

Try this:

=SUMPRODUCT(Table1[trans_amt], (Table1[trans_type]=H3)*(Table1[trans_date]>=TEXT(FromDt, "yyyy-mm-dd"))*(Table1[trans_date]<=TEXT(ToDt, "yyyy-mm-dd")))

[jstevens]

Hans,

Your suggestion worked.

Thank you.