How to integrate the top rows from new form entries into the COUNIF formula?

Pooja G

I am trying to lock the first row in my countif formula, but as the form gets new entries and the rows are added to the top, my countif formula changes does not capture the first row.

DKazatsky2

Hi @Pooja G,

You can adjust the form so all new entries will go to the bottom of the sheet instead of the top. The change can be made under "settings" in the form itself. This will leave the top row unchanged.

Hope this helps,

Dave

Pooja G

Hi, I tried this, but the responses don't populate in a series depending on when they are captured. I want to lock the formula range and the response entry.