Keeping sum up from forms coming in.

penny53731

I am hoping someone would be able to help . As per the diagram below I have the first 7 rows which need to be fixed as they take data from the forms being entered.

I have set up the form to enter the sheet from the bottom of the sheet, my objective is to have row 7 be a sum up of all the forms that are entered .

However the form does not come in as a child to the parent row so cannot sum up that way , I also tried just doing a straight sum up formula, however when I bring in a form it comes in under my formula.

Is there a way for me to have the forms come in and a sum up of that has come in?

Any help would be greatly appreciated.

Andrée Starå

Hi @penny53731

I hope you're well and safe!

Try something like this.

• Add a so-called helper column, Autonumber. In my example, I've named it Autonumber.
• Then set the number that the parent row is and sum/count all that is higher.

=SUMIF(Autonumber:Autonumber, >7, [BiFlex 10L]:[BiFlex 10L])

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!