sum if dynamic range

see attached file.  Col i is either debit or credit.  col j is an amount.  in cell s46 i have this formula sumif($I$15:I40,credit,Cash_Advance_Amount)  i have named the range "debit" as q46 Cash_A...