Help with excel formula Please

Hi All, Your assistance would be greatly appreciated as my brain has now melted trying to figure out what the problem could be. I have an Excel spreadsheet with multiple sheets. All of the sheets a...