Share via

How to update real time in excel

Anonymous
2018-02-04T20:12:51+00:00

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?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

25 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-02-05T13:09:44+00:00

    So how can I use the VLOOKUP to fetch data and display the sum?

    0 comments
  2. Anonymous
    2018-02-05T13:25:39+00:00

    =SUMIF(VLOOKUP(A1,DataSrv!A:P,1,false),'Students Entering District'!A1,DataSrv!G:G)

       I tried this formula but Excel keeps on responding that it is not a formula.

    0 comments
  3. DaveM121 816.5K Reputation points Independent Advisor
    2018-02-05T13:43:13+00:00

    Which cell did you enter that formula into?

    0 comments
  4. Anonymous
    2018-02-05T13:45:06+00:00

    I8 in Students Entering District sheet

    0 comments
  5. DaveM121 816.5K Reputation points Independent Advisor
    2018-02-05T14:30:46+00:00

    Sabir, that formula is incorrect for calculating - Total Number of Resident Students in School District

    If this is a school or college project, I cannot in good conscience do the work for you, it would be unfair on the other students in your class and can be seen as cheating.

    Also, under the code of conduct of this website, I would be breaking the rules and that could have consequences for both you and me . . .

    0 comments