Sum by Row using spill # (dynamic arrays)

[Tarek78]

Hi Everyone,

I have started using the great new dynamic array functions with 365. I have used a unique function that gives me an array (column B and C in blue).
I have used sumifs in order to get the revenue by month using the spill array # (column E to P)

I want to calculate the YTD figures which is the sum of each row column E to Column P. I wan to use a spill array so that I don't have to adjust it each time.

Can someone help me?

Thanks!!!

 

[Fluff]

Is columns E to P one single spill range, or one in each column?

 

[Tarek78]

Hi again Fluff,

Thanks, you have already been helping me twice today! Much appreciated.

I have attached a picture of the formulaes. For each column, I use the same spill array but I use Index to select the right column reference.

Let me know if it is not clear

 

[Fluff]

In that case you can use

=MMULT(E8#:P8#,SEQUENCE(12,,,0))

 

[Tarek78]

Thanks Fluff. I will check that today. If it works, how do we specify that my question has been answered?

 

[Fluff]

Just reply back here letting us know if it worked. You can also mark the solution Mark as Solution

 

[Tarek78]

Thanks got it!!

 

[Fluff]