ladies... I'm down and out.

After getting the diagnoses last month that my partner has Azoospermia he has just found out his little brother and fiancé are expecting. He is so down and out about it all. I feel so useless, I don't know how to console him. I mean I've had the case of sadness before we found out about the Azoospermia when I would hear announcements but I just can't stand how down and out about it he is. What can I say or do to help him heal?