For a good article on the ability of the Atheist community to offer consolation and comfort to suffering people please click on this link. http://www.nationalreview.com/articles/337673/atheist-response-sandy-hook-dennis-prager#
In opposition to the Atheist cold comfort response the bible offers this.
2Co 1:2 Grace to you and peace from God our Father and the Lord Jesus Christ.
2Co 1:3 Blessed be the God and Father of our Lord Jesus Christ, the Father of mercies and God of all comfort,
2Co 1:4 who comforts us in all our affliction, so that we may be able to comfort those who are in any affliction, with the comfort with which we ourselves are comforted by God.
2Co 1:5 For as we share abundantly in Christ’s sufferings, so through Christ we share abundantly in comfort too.
2Co 1:6 If we are afflicted, it is for your comfort and salvation; and if we are comforted, it is for your comfort, which you experience when you patiently endure the same sufferings that we suffer.
2Co 1:7 Our hope for you is unshaken, for we know that as you share in our sufferings, you will also share in our comfort. ESV.