Hi all,
i am currently struggling a bit with the following problem:
My Dataset:
Type Division Name Jan Feb Mar
a D Joe 10 15 16
b D Alex 11 14 30
I have monthly data for the past 3 years and up to May 2020 with 3 criterias (Type, Division, Name) in the above format. The months start in Jan17 and go up to May20. I would like to calculate the sum of a range of months (Jan till X) for a given year and for specific 3 criterias, in order to compare the intrayear progress throughout the periods. I started using a Sumproduct formula like: +sumproduct((Type="a")*(Division="D")*(Name="Alex");Offset(....))
The offset selects the same number of rows for Jan of Year X up until the chosen Month of Year X.
Nevertheless, the sumpoduct does not work and gives me a Value error.
Any ideas how to solve the above in anyway would be greatly appreciated.
Cheers
nf
Bookmarks