If the problem is just for one row, check that you don't have any extraneous spaces after the name on either sheet (e.g. 'Tom ' instead of 'Tom'). You can have however many rows you need above the 'Totals' row on the 'MonthStats' sheet.

Do note, though, that if you simply add new rows above the 'Totals' row on the 'MonthStats' sheet, the additional rows won't get included in the stats. That's because the formula in that row only sums rows 3:9. Try adding the new rows between rows 3 & 9, instead.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]