How to combine Formula "Sumifs" with "Arrayformula" in Google Sheets

[TanHo]

Hi all,

I have question about Google Sheets, but not sure if I post question to right place....

I tried to use formula of SUMIFS together with ARRAYFORMULA but it's look like not work... As my data is here:

Table A:

Table B:

I want to use Sumifs & arrayformula in Table A >> Column "Cash In Planned" where it auto update data getting from Table B by Year and month. This is formular that I use:

ArrayFormula(sumifs('Table B'!$I:$I;'Table B'!B2:B;C:C;'Table B'!C2:C;D2:D))

But it only show the result of Year 2024 & Month 1 for all column, not show data of other month like month 2,3,4,....

If someone know how to fix it pls help me. Thanks a lot for your support !!

[icrew]

Would https://support.google.com/docs/thread/18015573/how-to-use-arrayformula-with-sumifs-function?hl=en help, perhaps?

[TanHo]

Thanks for your sharing. I will check and follow on this guideline.