What I am trying to do is easy to solve using sumifs and if statements however I am required to solve this alternatively using sumproduct arrays.
I need to summarise the data below for energy sources across a time series. When the year is between the phase period, it will be divided by the phase number, if not it is simply left alone. Also it is not counted if the start year is not in play yet. See below.
8hhid.png
and therefore the solution is easy to summarise
w5Qwg.png
This is done easily above using sumifs and if statements as above. However I need/want to solve it via sumproduct array logic means. I tried to do this using
but it isn't giving me quite the correct answer and i am stumped! feel like i have stretched the limits of my ability here so any assitance would be very useful. aware that the sumproduct approach is not the best way to do this but i still want to figure this one out!
thanks
Bookmarks