Sum if Cell matches another on different sheet, but only keep one row to continuous tally sum

[Swissmiss]

Hello-

I am making a service trackers for hours earned by students. I have it set to sum their hours as they enter them, however, it creates a duplicate line with the total every time they submit a new entry. What do I need to add to my formula so that once a student is on the total sheet, it just sums on that row and doesn't add a duplicate row?

Link to image of my formula and sheet

Any help very much appreciated. TIA!

 

[oldbrewer]

name	hours
fred	1
ann	2
bob	1
fred	2
ann	1					fred	10
fred	2					ann	6
fred	1					bob	2
ann	2
bob	1
fred	2
ann	1					each time a student enters a new row of data
fred	2					the table on the right will update automatically
						is this what you want ?

<colgroup><col width="64" span="12" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[Swissmiss]

name	hours
fred	1
ann	2
bob	1
fred	2
ann	1					fred	10
fred	2					ann	6
fred	1					bob	2
ann	2
bob	1
fred	2
ann	1					each time a student enters a new row of data
fred	2					the table on the right will update automatically
						is this what you want ?

<tbody>
</tbody>

Yes, the only problem is that I don't know the kids names/id # ahead of time, so I need to only have it 1 one on the second sheet. Does that make sense? I got it to total, but it makes repeat rows based on how I set it up.

 

[oldbrewer]

name	hours
fred	0
ann	0
bob	0								Count of name
sid	0								name	Total
joe	0					tom	0		tom	1
tom	0					fred	5		fred	7
fred	1					ann	3		ann	5
ann	2					bob	1		bob	3
bob	1					joe	0		joe	1
fred	2					sid	0		sid	1
ann	1								Grand Total	18
fred	2
fred	1
ann	2
bob	1								put all the possible names with 0 hours at the start of your table
fred	2
ann	1								use a pivot table to list the unique names
fred	2
									copy the names into your master table
									you can copy them with a formula
									that says "" if the name is blank or grand total return a blank"""

<colgroup><col span="9"><col><col><col span="5"></colgroup><tbody>
</tbody>

 

[oldbrewer]

I used sumproduct to get the totals by the way