Need help with a formula (Excel 2000)

Topic

New Reply

I have attached a .xls and hoping that you can help me with a formula that I have been unsuccessful in creating (cell C48). I would like to add the the existing formula that I have in this cell:

=SUMPRODUCT((Capstone_Date=RDate)*ISTEXT(UW_Status),(Loan_Amt))

I would like the formula to look at CF_Status, UW_Status, and Closing_Status, and if any one of those fields has TEXT in them, and if so, then sum Loan_Amt. Is there a way to add OR into the existing formula that I have?

As always, thanks for the help.

Reply | Quote

Replies

Does this do what you want?

=SUMPRODUCT((Capstone_Date=RDate)*((ISTEXT(CF_Status)+ISTEXT(UW_Status)+ISTEXT(Closing_Status))>0),(Loan_Amt))

Reply | Quote

Legare,

That solved my problem.

Thanks!

Reply | Quote