I am not sure if I am phrasing this correctly or not. But I have a worksheet
I am working on that will allow me to help clients payoff debts and show
their debt to income ratio. The work sheet section has a list of the debts to
be paid off. I have four columns in this particular section. Acct. Name,
Account Bal, Mth Payment and a yes / no (Yes, count the debt in the ratio :
No don't count the debt.) The yes/no column is the trigger on whether to
include the debt in the total debt ratio or not. I don't know the formula on
how to accomplish this.

Any help would be appricaited.

Jeff

Name Balance Amount Yes / No
$1 IF(M21="yes" THEN COUNT
$1
$1