Hey guys,
Need advice, so, I have table, and the table will be filled on daily basis, but I need to track all the data. it will be thousands of entries.
you can cee, in screenshot below the table. There will be about 70 Rooms, and each room has at least 10 codes. and for each of these combinations containing each room and code, I need data - total M2 and total time.
Same combination could be entered many times, so I need sum of that.
I know, pivot can do this, but data is not entered yet, it will be entered on daily basis, so it would not really help me. I need, that the result sum will update aomatically, as new data is entered.
so result should look like this:
and so on with next room. and in this case, M2 and time is calculated sum from first table
which formula, or tool would you use for this?
Need advice, so, I have table, and the table will be filled on daily basis, but I need to track all the data. it will be thousands of entries.
you can cee, in screenshot below the table. There will be about 70 Rooms, and each room has at least 10 codes. and for each of these combinations containing each room and code, I need data - total M2 and total time.
Same combination could be entered many times, so I need sum of that.
I know, pivot can do this, but data is not entered yet, it will be entered on daily basis, so it would not really help me. I need, that the result sum will update aomatically, as new data is entered.
so result should look like this:
and so on with next room. and in this case, M2 and time is calculated sum from first table
which formula, or tool would you use for this?