Formulas that can account for additional data

I am trying to set up a spreadsheet with formulas that will do some simple counting calculations. I know how to set up the formulas, but the sticking point is that I was hoping to find a way set up a spreadsheet with the formulas that will accommodate new data.


The data is patient visits for resident physicians, and I need some faculty to be able to paste the data into a spreadsheet and I want the spreadsheet to have the simple count formulas set up somewhere. Each time the faculty will paste the data, there will be more or less data each time, so the way I know how of inserting a formula in a set cell with a fixed ranged is something I know will not work.

Example: in the fall, there might be 50 rows of data and in the spring there might be 100. I know I can use a new sheet and put the formula to count the data in question there, but is there a way to make the formula accommodate a range that varies?

Thanks in advance for any ideas.

Thank you! Definitely food for thought and things to try. I really appreciate it.