1st formula - working: =SUMIFS(Table1[Amount],Table1[Amount],"<0",Table1[Account], "Chase Personal", Date_Trans._Processed,">=1/1/17", Date_Trans._Processed, "<=1/31/17")
2nd formula - not working: =SUMIFS(tableamount,tableamount,"<0",account,"chase checking",dateprocessed,">=1/1/18",dateprocessed,"<=1/1/18")
What am I trying to accomplish with the formulas? I want the total expenses for the month of January from my checking account. I have a giant table that helps me classify any and every transaction I make, be it a deposit, transfer, or expense. The above formula looks for any value less than zero in the column of my table that lists the cost of each transaction ("Table1[Amount]" in 1st formula, and "tableamount" in 2nd formula) IF the neighboring rows of the column that lists the account used in the transaction is my checking account ("Chase Personal" in 1st formula, and "chase checking" in 2nd formula) and the column that lists the date the transaction occurred, falls between the 1st and 31st of January, 2018 ("Date_Trans._Processed" in 1st formula, and "dateprocessed" in 2nd formula).
Yeah, really confused as to why one and not the other would work. Would appreciate some insight. I attached a doc that has "fake" transactions, and only the information needed for the 2nd formula to work.
Bookmarks