Let me see if I can clarify what I must do.
I’ve a sheet in Google Drive and in it there may be many tabs, every tab is for a metropolis and for the variety of Covid circumstances on this metropolis.
In some tabs I’ve each day updates, in others the updates come three occasions a day. For instance:
- 20/04 10
- 21/04 12
- 20/04 5
- 20/04 7
- 21/04 8
- 21/04 8
In a special tab I would like the sum of values on the finish of the day, e.g. 20th=17, 21th=20.
I can’t mix at all times the identical, as a result of in a single case the final worth of the 20th can be on second line, in different tab can be on first, in different it is likely to be on fifth.
What I would like is a few form of system/command that at all times get the final row of every worth within the first column(date) and get the values from the identical row in different columns:
If the final line of 22/04 is on A9, it will get the worth of B9 – if in different tab is on A4, get B4 worth.
Is there such a risk?