However, that's throwing an error. Some quick googling has suggested it's because I'm using an aggregate function within another one, but I'm not sure how to get around that.
If it possible to do anything with directly editing the script? I wasn't directly involved with the development, so I'm just working on a sheet on a document using QVD (And I have no idea where the files that created the QVD files are located)
Many thanks, Joseph Garner.
P.S If the general =sum(if(etc)) code is poorly optimised, please also mention that.