Hacker News Reader

I faced this before. I have a solution: Open up PHPMyAdmin, show them how it looks like in a proper database.

Then show them how to lock panes in Excel. Problem pretty much solved.

I think danso's problem would also be solved by showing them pivot tables in Excel.

sumifs || dsum an alternative too.

sumproduct rules my world when it comes to this.