How return substring of count for override for found december etc?

I don't think I ever posted here, so hopefully all is good.

I have a spreadsheet that will always return varying row contents. So I need to search each row to find the january, february, march, april, may, june, july, etc content and extract the counts from that in the cell with substring. I'm not certain how to do this since the location in the row will always vary. Any ideas? I was thinking vlookup or index or match, or mid/search, but I'm not sure.

Example spreadsheet content, notice some rows have the overallCount and some have overrideCount, and a string like "overallCount 2022/12 35" is the complete cell value, where 2022 is the year, and 12 is the month:

(I'm not sure how to get the rows to line up here)

Please Login or Register  to view this content.

And the rows can have varying column numbers as well if there are more or less orders for each device.

I want to add a formula in result8 column or so, and search to the left of each row, and pull out the counts in columns for Jan, Feb, March, April, May, etc. I was thinking of something like this:

Please Login or Register  to view this content.

but it's not returning the count. It's returning #N/A

example per-row output on the right:

Please Login or Register  to view this content.

As you can see, not every month has a count that would be found in the row.
How would I pull those monthly counts for overall and override out to the right in each row?

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.