Everyone handles grief in different ways. Some want to be consoled, others want to be left alone, and anything in between. While I do feel saddened by the loss of someone close to me. I do find comfort in Ecclesiastes 7:1 A good name is better than precious ointment, and the day of death than the day of ones birth.
This pasage never made sense to me until the day my daughter was born. Because my first thoughts, for whatever reason, was a mixture of joy and sadness. The sadness came from the realizatiom that today was her first day of "life", and how much pain and suffering she would have to endure over the course of her entire life in the coming years.
Where as even if you don't believe in an afterlife. One thing you can take comfort in when someone dies is that the pain of life is over. They no longer have to endure heartbreak, anger, jealousy, or physical pain. They are free, and I believe that should be rejoiced! At least to some extent.