vendredi 12 juillet 2019

Arrayformula addition of two cells

I have a simple formula that calculates the time based on the cell above it and a cell in another column.

How do I translate this to an array formula?

(in cell L2)

=arrayformula(L1:L18+E2:E19)

this is my intuition but it results in a #ref

Aucun commentaire:

Enregistrer un commentaire