How to populate down the current formula automatically

[kvngo94]

Hello all, 

Below is sample excel file download link

https://docs.google.com/spreadsheets/d/1D0dcTzfD7f1irtaWtTTaewJqqdFH4b0p/edit?usp=sharing&ouid=11458... 

As in cell B3 and C3, when I put below formula, it will automatically populate down the following cells

But for D3, I have tried many ways but not know how to make it populate down as the other 2 previous columns.

Could you guys please help me with this ?

I also added the DESIRED RESULT sheet for the desired result I want for the D column

Desired result 

[#2]

@kvngo94 Duplication from here

https://techcommunity.microsoft.com/t5/excel/how-to-populate-down-the-current-formula-automatically/... 

[#3]

@kvngo94 

The formulas in B3 and C3 are SUMIF formulas that specify a multi-cell range as criteria argument:

INDIRECT("A3:A"&COUNTA(A:A)+1)

So they automatically return a result in multiple cells. The formula in D3 uses TEXTJOIN; this function is designed to concatenate strings into a single result. It fails if you try to make it return multiple results.

Just fill down the formula from D3 to D6.