Multiple user entries

i am trying to create a website for step-athon. This is a restricted page for members only. each member would log in daily and enter their step count for the day. each user would do this everyday for one week. after one week database would reset. i have created another table as a dashboard for all the user entries where i’d like to show name of the user and sum of total steps that user have entered so far. so if anyone check the dashboard on Monday after user entries are done, they should be able to see everyone’s sum for Sunday and Monday. and so on as days of week pass by.

i am stuck as while trying to take entries each entry generates a different row in the database. i am looking for help to generate a logic so i can make a total of each user entry as they input and show all sums with each user’s name in the dynamic page.

Please help.

Thank you.