Got a bunch of lines, always first cell is title which is “Notes” and then the cells might be empty or contain the legend “Pallet contains X empty case(s) due to wrong scan procedure” where X is the number I need to extract and goes from 1 to infinity.

I need to extract all those numbers and them up and show result in a cell at other position. So for example for the attached image, it should return 115.Sample

By using this formula:
=IF(OR(O1=””,O1=”Notes”),0,MID(O1,17,LEN(O1)-58)*1)

I am able to extract the number into the cell next it and return 0 if it is blank or the title.

I tried turning that formula into an array, but it simply does not work… Ideas on how to turn this into a single cell formula array?