ARRAYFORMULA is only populating the first row-CodePudding

I have financial data that I am trying to summarize in a format that can be used by a line chart.

The example spreadsheet is

CodePudding user response：

Use formulas like this

=ARRAYFORMULA(IF(H2:H="",,SUMIFS($F$2:$F, $A$2:$A, $H2, $B$2:$B, I$1)))

Add IF(H2:H="",,

Explanation
if the range is empty "" do nothing ,, else Your formula

Your Example

Cells	Formulas
I2	`=ARRAYFORMULA(IF(H2:H="",,SUMIFS($F$2:$F, $A$2:$A, $H2:H, $B$2:$B, I$1)))`
J2	`=ARRAYFORMULA(IF(H2:H="",,SUMIFS($F$2:$F, $A$2:$A, $H2:H, $B$2:$B, J$1)))`
K2	`=ARRAYFORMULA(IF(H2:H="",,SUMIFS($F$2:$F, $A$2:$A, $H2:H, $B$2:$B, K$1)))`