This question already has an answer here:

Here is an example situation which I would like to achieve using ArrayFormula:

Column A is the data, column B is the calculation.

desired output

Here is an implementation without ArrayFormula:

implementation without ArrayFormula

Here is how I tried to convert it so I wouldn't have to expand it by hand whenever there is a form-submission (which unfortunately inserts a new row instead of adding just the data):

ArrayFormula attempt

But as you can see this gives me a circular dependency error:

ArrayFormula error

Which is not strictly true; while the calculations do depend on each other, they never depend on themselves, so it should be possible to calculate them.

Is there any way to achieve this? Or maybe there is a way to make regular formulas expand automatically?

Note: I am using Google Sheets for this, so I am mainly interested in solutions for that tool.

marked as duplicate by Jacob Jan Tuinstra, Rubén, Alex, Sathyajith Bhat Jul 25 '15 at 15:29

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.

migrated from superuser.com Jul 20 '15 at 16:43

This question came from our site for computer enthusiasts and power users.

Browse other questions tagged or ask your own question.