How to update real time in excel

Question

We were told to remake this excel file. The sheet should update the numerical information when a number is given above(like 152 on the image). We are supposed to fetch data and from a different work sheet and display the sum in the boxes. How can I do it?

Answer 1

So 6752 is when you add up the ADM numbers for the respective district.... for example when we enter 152 on A1 of 'Student Entering District', Then 6752 will show up on I8 of the same sheet.. That's because it adds up all the ADMs in the DataSrv sheet that corresponds to Moorhead.

hope you understand.

I think SUMIFs and VLOOKUPS used together would be helpful but I'm confused on how to  use them together.

Answer 2

Total Number of Resident Students in School District

=SUMIF(DataRes!$A$5:$A$10454,$A$1,DataRes!$G$5:$G$10454)

Total Number of Students Served by the School District

=SUMIF(DataSrv!$A$5:$A$10454,$A$1,DataSrv!$G$5:$G$10454)

You need to guide me Students Leaving District and Students Entering District - Which columns should I read for Enter and Exit

Answer 3

I did not get what you said about me guiding you Students Entering and Leaving District. How would you want me to help you?

Answer 4

The logic for finding out Students Leaving and Entering. Now, your two entries are fixed.

Answer 5

okay, Student entering district would be the sum of ADMs of a given district in DataSrv excluding the district it self. For Student Leaving District, it is the same thing but in DataRes sheet.