Extract numerical values to find total sum from string

[Monica_Spaunho1]

I am new and teaching myself databases and AirTable so please be gentle. :grinning_face_with_big_eyes:

I am trying to extract the numbers from the {Recipe} column and add them all together to figure out the total number of drops for each blend. Is it possible to do this with my current setup? I have figured out how to extract the numbers but it just smooshes the numbers to become a 2-6+ digit number.

I hope this makes sense.

[Dominik_Bosnjak]

Yes, use Value() to parse the floats. And welcome to the community!