Hi everyone,
I have multiple worksheets (Sheet2, Sheet3, etc.) with values in columns B and C that I want to summarise in Sheet1.
I am trying to use a 3D sumproduct function, but it is not working - I'm just getting the #VALUE ! error. I don't have a coding background and have tried cobbling...