SUMIFS function & formula

I am in need of a formula where

Budget!B4 = the sum of TJC_Payment where MONTH(TJC_Post_Date) = 1 && YEAR(TJC_Post_Date)=2019 && RIGHT(TJC_Desc,4) = "Loan" (case-insensitive)

I tried this formula:

=SUMIFS(TJC_Payment,TJC_Desc,"*Loan",TJC_Post_Date,">=" & DATEVALUE("1/1/19"),TJC_Post_Date,"=<" & EOMONTH("1/1/19",0))

and the formula returned $0.00, even though there are dates in TJC_Post_Date between the two serial numbers

Tim

Oh how I hate Micro$oft. I could have done this in my sleep in two minutes in MySQL.

@Pete:

you can't apply a function to the criteria ranges

and

RIGHT(TJC_Desc,4),"Loan"

This is what ended up working:

=SUMIFS(TJC_Payment,TJC_Post_Date,">="&DATEVALUE("3/1/19"),TJC_Post_Date,"<="&EOMONTH("3/1/19",0),TJC_Desc,"=*Loan")

and did the same for all seven months!!

Thanks for the help!

Administrative Note:

Welcome to the forum.

We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

Please see Forum Rule #4 about hijacking and start a new thread for your query.

If you are not familiar with how to start a new thread see the FAQ: How to start a new thread