Hi, I hope someone can help me with this...
I have a table with dates in the headers, rows with fruit products sold in different countries and I'm trying to sum f.i. total Apples sold in the UK as well as FR, based on 40 (iso weeknumber) and later 10 (being the month oct.).
I've tries different variations om sumproduct and sumifs but I only get #value results.
Many thanks in advance for helping me out....
example.png
Bookmarks