How to Use Array Formula Google Sheets | Scribe

    How to Use Array Formula Google Sheets

    • Alejandra Arciniegas |
    • 8 steps |
    • 53 seconds
    • Google SheetsGoogle Sheets
    1
    Using the array formula in Google Sheets is really simple. Let's see how to do it. The first thing you should do, is to open you spreadsheet document.
    2
    Once you are in your document, select the cell where you want to have you array formula on.
    3
    Then, you should type "=array"
    4
    You'll get some dropdown options. Select the one that says "ARRAYFORMULA".
    5
    The syntax for an array formula is normally this one: - **=ARRAYFORMULA(array_formula)** The parameter can be a range, a mathematical expression that uses ranges of the same size, or a function that returns a result that is greater than a single cell. For this example, I will use it to sum the numbers of 2 columns (AKA, a mathematical expression that uses ranges of the same size).
    6
    So now, I'm typing "SUM"
    7
    Now, I select the range of cells, which would be: "(a2:a10,b2:b10)". And then I just hit enter.
    8
    That's all! you'll get the result from your array formula.