If Yes, then Add question

[JT]

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

 

[Dave F]

You're looking for a formula that has the following syntax:
=IF(A1="Yes",B1+C1,C1). Here I'm assuming that A1 has the yes or no, B1 has
the debt amount, if any, and C1 is the total debt ratio. If that doesn't
help make clear what you need to do, please post back.

Dave

 

[bj]

assuming the amount column is column L and the yes no column is column M and
the data is in rows 21 to 30 try
=sumif(M21:M30,"yes",L21:L30)
adjust as needed.