Hi,

I have attacehd two excel sheets 1st is the Tracker where the data is inputed and 2nd is the Master file. When both the files are open the Sumifs formula works fine but when I only open the Master file it gives me a #Value error. I tried to search a solution and found that Sumproduct can be useful in such scenarios but I do not have any idea how to use Sumproduct. I am totally open with suggestions.

Thanks in advance.MAIN SHEET.xlsxUNIT TRACKER.xlsx