COUNT formula not working on form submissions due to row numbers changing

JamesB

@Paul Newcome Thank you for the clarification. I understand how the formula works, I think it just has a dependency that the row numbering be in descending order in the Auto column correct?

Paul Newcome

@Shane Beam Can you provide a screenshot of the column properties for the auto-number column?

@JamesB Yes, but that is fine in this instance because new rows are being added to the top of the sheet via form. If you wanted to pull the top 30 rows from the sheet regardless of where new rows were inserted, you would still use the auto-number column, but then you would insert another text/number column (called "Row" in this example) with the following column formula:

=MATCH(Auto@row, Auto:Auto, 0)

Then your SUMIFS would change to this:

=SUMIFS([Near Miss Numeric]:[Near Miss Numeric], Row:Row, @cell <= 30)

JamesB

@Paul Newcome Thanks again.

Shane Beam

@Paul Newcome Not sure what exactly you are looking for, is this it?

Paul Newcome

@Shane Beam I mentioned before about inserting an auto-number type column and leveraging that in the SUMIFS. Can you provide a screenshot of the auto-number column properties?

Shane Beam

@Paul Newcome sorry, i missed the auto number column part. i am not familiar with using this type of column at all, it will not let me input the formula in to that column and when i enter in any other column it does the same this as before. here are the column properties:

Paul Newcome

Ok. make sure the formula you are using has an exact match on the column name being used in the sheet.