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! Go to Solution.
Try replacing SUM(SPLIT([Width],"+"))
with SUM(LIST(0) + SPLIT([Width],"+"))
.
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
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |