# google sheets – Using ARRAYFORMULA extensively in complex formulas

I have a formula which looks like this:

``````=ARRAYFORMULA(IF(A4:A = "", , IF(AND(ISNUMBER(I4), ISNUMBER(J4), ISNUMBER(K4), ISNUMBER(L4)), SUM(I4:L4), "???")))
``````

The idea is that for each row in the sheet, those four cells are added if and only if they are all valid number, otherwise `???` is displayed.

What happens in the above formula is that each row is set to the sum for the 4th row, and only if values in the 4th row are numbers.

If I put a range in `ISNUMBER`, then it checks if ALL of the column is a valid number, and I don’t really know how to define a `SUM` for this case.

How do I make it act as I described? I need the `ARRAYFORMULA` since this is a part of the sheet that takes the responses from another sheet and does calculations on the input. Since each response is added as a new row, all my formulas get shifted (and thus, they omit the new response), unless I use `ARRAYFORMULA`.