I have been pulling my hair out for 6 hours trying to find an answer to my dilemma on Sheets. You not only showed how to use Array Formula, but you explained how it worked! Thank you, thank you, thank you!
The trick of replacing the cell references with range references is super helpful! I think that was what made me understand how to use arrayformula. Thanks!
Hello. I want an arrayformula that sum the at right cell value with the above value like (in C2 cell) "=B2 + C1". Using "=ArrayFormula(B2:B + C1:C)" create a circular reference. Thanks I understand I have to turn on the Iterative Calculation on Options. Now it works...not really. the results are ok, but not all the lines. In the middle it start miscalculation. I alter a value in sheet and the ArrayFormula is revaluate. Some lines down and the same happens. Any idea?
I have been pulling my hair out for 6 hours trying to find an answer to my dilemma on Sheets. You not only showed how to use Array Formula, but you explained how it worked! Thank you, thank you, thank you!
The trick of replacing the cell references with range references is super helpful! I think that was what made me understand how to use arrayformula. Thanks!
Thank you so much. Finally understand array formulas. EASY!
Very helpful video! Thank you!
Hello. I want an arrayformula that sum the at right cell value with the above value like (in C2 cell) "=B2 + C1". Using "=ArrayFormula(B2:B + C1:C)" create a circular reference. Thanks
I understand I have to turn on the Iterative Calculation on Options. Now it works...not really. the results are ok, but not all the lines. In the middle it start miscalculation. I alter a value in sheet and the ArrayFormula is revaluate. Some lines down and the same happens.
Any idea?
very2 good