Hello,

I need to add together all relevant line items for the changing month based on a number of criteria. I have tried a combination of SUMIFS, HLOOKUP, MATCH and INDEX to achieve this but to no avail.

I have attached the bugger so you can see for yourself the pickle I'm in. Any help would be appreciated.

Regards,
Diana