How I can find numbers in sum in the 1 column

Hi All,

case:
I have data in column A1 with text format

"Manggo","quantity":1,"Orange","quantity":5,"Cake","quantity":4;

I want to some total of quantity, the value is should be 1+5+4 = 10

I have about 1000 rows, and I don't know how I can find and calculate it.

really appreciate your help.

Zanis

Hi Bro,


Thanks for help, its work, but I have more question on that,

I will only counting numbers after "quantity":

because sometimes there are the others number but does not need to counting

example:
"Manggo","quantity":1,"Orange","price":1000,"quantity":5,"price":3000,"Cake","quantity":4,"price":2000

same, the result should be 10,

Hi bro,

I think still cannot solve my problem,

So there are many number, but I only will take the number after word "quantity":XX, and also there are >=1 the quanitity, and i need to some all quantity

"available":true,"comment":"","name":"Es Teler 77","priceInMajorUnit":"34000.00","quantity":2,"simplePriceInMajorUnit":"34000.00","quantity":3,

from this case the sum is 5,