google sheets - Why isn't the arrayformula applying to the entire column?

Question

I have the following formula in cell D2 of this sheet. The formula itself is in an "arrayformula" and the formula itself works, but it isn't automatically applying to the entire column - I have to manually paste the formula in order for it to work in each cell of the column even though it has the arrayformula in it. How could I fix this?

Here is the formula that I've used:

=ArrayFormula(SUMIF('RAW ACTIVITY LOGS IMPORTED'!$C$2:$C,A2,'RAW ACTIVITY LOGS IMPORTED'!$F$2:$F))

question from:https://stackoverflow.com/questions/65927363/why-isnt-the-arrayformula-applying-to-the-entire-column

Answer 1

try:

=ARRAYFORMULA(IFNA(VLOOKUP(A2:A, QUERY('RAW ACTIVITY LOGS IMPORTED'!C2:F, 
 "select C,sum(F) group by C label sum(F)''"), 2, 0)))