Learned people I have a spreadsheet of data downloaded from an order form in Jotform. In certain cells there is a value such as Tomato Red Alert [1]

What I would like to do is 'Sum' the numeric values from each cell at the bottom of the column

I have deleted the [] and then used the RIGHT function as an experiment/test but I would have to do this in almost every column which would be very time consuming

many thanks in advance for your kind assistance

Peter