How do i fix this formula from excel omits adjacent cells (note: it is on a excel table which prepopulates the formula but comes up with the error)

Formula: =SUMIFS(D$2:D2, B$2:B2, "<>credit", B$2:B2, "<>transfer")