Hi Guys and Gals,
In the attached what I'm trying to do is sum the total area figures for a particular month per company and product. The data is on sheet 2 and the summary table is on sheet 1 just in case there is any confusion on that front. The only thing I have managed to come up with is to do multiple SUMIFS functions and add them together. This seems a messy way to go about doing this and I feel there must be a better method of doing this hence why I'm posting here and hoping you'll be able to help or point me in the right direction as I'm stumped. I've tried using SUMPRODUCT but to no avail, maybe I'm doing it incorrect.
Appreciate any help you can provide
Lewn
Bookmarks