Help with a formula please

hello smart people. Gemini Advanced (ai) couldn't figure this out so I'm hoping you can... There is a file called 'SCWI Tracker - WIP.xlsx' with a tab labelled 'Course Data' containing many colu...