Quote from train93
Well, Chrno Crusade had kind of a tragic one, in my opinion:
Spoiler (mouse over to view)
Rosette did die at a pretty young age after all
Thanks to all of you!
Sorry, I probably have a different vision of "not tragic ending" then and some of my suggestions could be off in that case. I apologize. A not tragic ending for me is something that ended in the best possible rational way considering the (bad) premises. So computing the premises of the story, I can't figure a better rational ending for Chrono Crusade.
Spoiler (mouse over to view)
You know from the start that since she was shorting her life by using that power she'd have died young. But since the last page shows her finally reuniting and embracing Chrono, I consider it the happiest ending she could have hoped for.
Similar, if you plan to read Gunslinger Girl (and you should anyway because it's awesome) without spoilering too much, you pretty much know that there are gonna be deaths in that story, but since last chapter is a message of hope, I consider it a not tragic ending since it brings you a positive message
If you want something that magically and irrationally ended well despite every possible premises, you could check
Mai-Hime anime or manga (but I only watched the anime so I don't know if the manga is the same).
________________
What I like in Trivial Pursuit style. Pick your category: