Romans 12:15:

Rejoice with them that do rejoice, and weep with them that weep.

See also:

All About Healing Services
What Can You Say to Someone Who Just Lost a Loved One to Sickness?
Notes on John 11:1-44