Using a table to track hourly performance

[SCPbrito]

I have data set linked below that i download every hour to track hourly performance. I track it using user ids which vary day to day depending whos on staff. Currently using a pivot table to display this info but i would like more control of the data and make it cleaner. I started doing it using formulas as you can see below in screenshot but its very cumbersome and I would have to manually add and delete users based on whos working. so can i use a table to display this information and manipulate it more freely?

=ABS(SUMIFS(Items!$L:$L, Items!$F:$F, "Shipment", Items!$U:$U, "Emolina", Items!$E:$E, ">=" & TODAY() + 7/24, Items!$E:$E, "<" & TODAY() + 8/24))

Item Transaction (28).csv

drive.google.com

 

[kvsrinivasamurthy]

Here there is only one user "Emolina". You mean number of users will change . They are to be added.

 

[SCPbrito]

Yes. That just a sample. I would have to manually add each user who is on shift

 

[kvsrinivasamurthy]

If you want the total of few selected Names, enter the names in say AK2:AK8.

=SUM(ABS(SUMIFS(Items!$L:$L, Items!$F:$F, "Shipment", Items!$U:$U, AK2:AK8, Items!$E:$E, ">=" & TODAY() + 7/24, Items!$E:$E, "<" & TODAY() + 8/24)))

It is always better to avoid referring whole column (Eg:C:C) or row. Refer the range (C1:C10000).