Perform calculation without eliminating DR & CR
1.2 هزار بار بازدید -
4 سال پیش
-
Most of the time when
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")))
4 سال پیش
در تاریخ 1399/02/25 منتشر شده
است.
1,200
بـار بازدید شده