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
#ref
Aucun commentaire:
Enregistrer un commentaire