I don't think they were using Excel's weighted average function in this case but simply averaging filtered figures per country and then averaging the averages.

I don't think they were using Excel's weighted average function in this case but simply averaging filtered figures per country and then averaging the averages. This has no statistical basis, but it's not Excel's fault