Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need help with a formula (Excel 2000)

    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.

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need help with a formula (Excel 2000)

    Does this do what you want?

    =SUMPRODUCT((Capstone_Date=RDate)*((ISTEXT(CF_Stat us)+ISTEXT(UW_Status)+ISTEXT(Closing_Status))>0),( Loan_Amt))
    Legare Coleman

  3. #3
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need help with a formula (Excel 2000)

    Legare,

    That solved my problem.

    Thanks!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •