I am afraid I cannot help you with this. The file has external links to a sharepoint file which I obviously cannot access. And, even if I remove the sharepoint file references, I am left with references to two sheets that don't exist in the sample file.
As I don't know what is in those sheets, or how they are laid out, I cannot even consider setting up a test bed.
The formula, even with the external references removed, is far more complex than indictated.
You would need to provide a copy of the sharepoint file in order to investigate further,
Bookmarks