I am trying to add up vlookups on one page. I have got one summary page on which I am trying to add up (merge) data across 3 sheets based on the criteria on the summary page. Because one of the data sheets may not have any data, the overall sum formula returns N/A. How do I solve this? It seems a very simple task but I am stuck. I have searched through the forum and came across a sumproduct formula but even that doesnt work. Please help. Attaching workbook.
Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.