Using COUNTIF in a live document

Visitor
Hello, I hope someone can shed some light on this.

I have created a series of MS Forms connected to a live Excel worksheet which all works perfectly and the data self populates when a form is submitted. I want to add additional columns to the worksheet that will then update when the data hits the page. For example I have used the following as I want to be able to see how many times the person has submitted a form.

=COUNTIF($G$2:G$100,$G2)

But the issue is when the document updates and a new line of data is added, the values in the formulas in the added columns bump down.

Is anyone able to help? Not sure if it is important but the document is an online worksheet.

Many thanks!
Sarah
0 Replies