Perform calculation without eliminating DR & CR

Most of the time when data is exported the numeric value comes along with text in single-cell and no analysis can be performed, so here is a formula where you can perform the calculation of DEBIT and CREDIT figures without doing anything manually. Sumproduct basic video:    • SUMPRODUCT concept with a bonus tip   Formula used: SUMPRODUCT((LEFT(B2:B9,LEN(B2:B9)-2))*((RIGHT(B2:B9,2)="DR")-(RIGHT(B2:B9,2)="CR")))

• #education
• #sumproduct
• #do_not_eliminate_dr_and_cr
• #calculation_on_text_and_numeric_value