Nov 11 2021 12:07 PM
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.
Nov 11 2021 01:19 PM
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)