Sum Text Cell Containing Number

Amit_Jain1
Participant III

How Can I Sum Cell Value (Formated as Text) Separated by Delimiter “+” I have Tried with This Formula but its showing Error
The ‘SUM’ function requires a list of numeric inputs

Here Is My Formula
IF(AND([Material]=“BOPP”,[Unit]=“Pcs.”),(SUM(SPLIT([Width],"+"))SUM(SPLIT([Length],"+"))[Gauge]) /880*[Order Pending Qty.]/1000)

Hill to Solve This Issue

Solved Solved
0 4 550
1 ACCEPTED SOLUTION

Steve
Participant V

Try replacing SUM(SPLIT([Width],"+")) with SUM(LIST(0) + SPLIT([Width],"+")).

View solution in original post

4 REPLIES 4

Steve
Participant V

Try replacing SUM(SPLIT([Width],"+")) with SUM(LIST(0) + SPLIT([Width],"+")).

No Success.

Whoops! Should have said to repeat for each SUM(SPLIT(...)) occurrence.

IF(AND([Material]=“BOPP”,[Unit]=“Pcs.”),(SUM(LIST(0) + SPLIT([Width],"+"))*SUM(LIST(0) + SPLIT([Length],"+"))*[Gauge]) /880*[Order Pending Qty.]/1000)

I had Done Repeatedly on Every Occurrence
The error was from my Side
Anyway Thanks

Top Labels in this Space