Hello All I have been trying to get this working with no luck. ACHfilter and QBfilter are returning #Value error. They run fine when there is only one filter but with two filters they mess up. I feel like I am missing something simple. Anyone got ideas?
=LET(
MonthStart, EOMONTH(AZ$5,-1)+1,
MonthEnd, EOMONTH(AZ$5,0),
LoanID,$D6,
ACHFilter,FILTER(ACHamt,(ACHloanID=LoanID)*(ACHDate>=MonthStart)*(ACHDate<=MonthEnd)),
QBFilter, FILTER(QBamt,(QBLoanID=LoanID)*(QBDate>=MonthStart)*(QBDate<=MonthEnd)),
IF(SUM(ACHFilter)<>0,0,SUM(QBFilter)))
Bookmarks