Sum a row of "If Then" Formulas

Occasional Visitor

I want to sum several columns that each row has variations of this formula: If (A5="Rent", D5,0) or Pepco, Wash Gas


Think of a bank statement and you want to total your expenses for several categories. 

1 Reply


You have lots of circular references.

The formula in AS7 makes no sense. Delete it.

The formulas in column J are useless. They will always evaluate to 0. Delete them.

The formulas in column K are of the form =IF(K5="RENT",E5,0)

This should be =IF(H5="RENT",E5,0)