Ask Lemmy

Happier - by Bastille and Marshmello. It might depend on the listener tho.

Aint it fun - Paramore

Honestly, i don't like that a lot of radio music is so sad. I have to look to real oldies to find a happy song.

pretty much anything by third eye blind

HEALTH - everything from the band is banger after banger but with lyrics that'll leave you feeling a certain type of sad

Plenty of ABBA songs... Maybe Chiquitita?

You are my sunshine (The Dead South do an excellent job illustrating how dark the song really is)

Little talks - of monsters and men
It sounds very chill and upbeat but it’s about the loss of a loved one

Sad lyrics and fast tempo :
Kazim Koyuncu - Narino
Bagpipe song with the lyrics "I lost my sanity", "I sat down and cried", and "I wish someone knew my pain" especially. Can find longer versions on youtube.

French Gal - Poupèe de cire
Lyrics are about feeling more like a doll than human. TRIGGER WARNING FOR FRENCH LANGUAGE

Kazim Koyuncu - Fadime
Kemençe song with lyrics along same lines. Takes a bit before beat changes.

Sad lyrics and happy music/tone :
Danny Gonzales - Downhill
Song argues with a young adult on how rest of their life will suck.

Istanbul12 Orkestrasi - Bile Bile
Song about being unable to accept rejection.

Ayase/YAOSABI - Into the night
I am 70% sure "upbeat sounding song about suicide" is a genre in Japanese music.

I Am A Rock by Simon and Garfunkel

A winter's day  
In a deep and dark December

I am alone  
Gazing from my window to the streets below  
On a freshly fallen silent shroud of snow
I am a rock I am an island

I've built walls
A fortress deep and mighty
That none may penetrate
I have no need of friendship, friendship causes pain
It's laughter and it's loving I disdain
I am a rock I am an island

Don't talk of love
Well I've heard the word before
It's sleeping in my memory
I won't disturb the slumber of feelings that have died
If I never loved I never would have cried
I am a rock I am an island

I have my books
And my poetry to protect me
I am shielded in my armor
Hiding in my room safe within my womb
I touch no one and no one touches me
I am a rock I am an island

And a rock feels no pain
And an island never cries

Brown Sugar

A lot of that album was pretty subversive but hidden behind upbeat rock. The olds didn't realize what the kids were listening to because they just heard pop rock.

Radiohead - No Surprises

Ring around the rosey

And

Fuzzy wuzzy was a bear

Nothing but Flowers by Talking Heads is a cheerful song about post-apocalyptic life.

Flagpole Sitta - Harvey Danger?

Mmmm Bop

The only 2 songs I could think of, Pumped Up Kicks, and 99 Luftballons/99 Red Balloons were already brought up. So I had to think of some different songs. And I can't. Looked through a bunch of songs on my phone and back of some of my CD cases and I can't think of any right now.

Closest I can think of was just a video of someone reacting to the Japanese vocaloid song 「ごめんね ごめんね」 ( I'm sorry I'm sorry )by Kikuo and not knowing what the song meant until looking up the lyrics. Even then, that's not a very upbeat song.

Edit:

I thought about "Belong" by R.E.M., but I would say it's near upbeat but not quite there. Also, the lyrics are more cryptic and confusing to dissect than depressing in my opinion.

Edit 2:

Wouldn't say it's quite upbeat either, but Mighty K.C. from For Squirrels as well. Not quite upbeat but definitely depressing lyrics considering it's about death.

Walking on broken glass - Annie Lennox

Pumped Up Kicks - Foster the People.

Billy Idol - Dancing with Myself Loneliness masked as liberation.

Bulletproof - La Roux Emotional numbness disguised as empowerment

Some Linkin Park songs (Bleed it out, Up from the Bottom, etc.)

There's so many such songs...

The Science of Selling Yourself Short by Less Than Jake

Not entirely upbeat, but people always play Linger by the Cranberries like it’s a love song. Most definitely isn’t.

I think Enola Gay by Orchestral Manoeuvres In The Dark is a perfect example.

It sounds upbeat and fun but it's about the atomic bomb dropped on Hiroshima.

Some of the lyrics are incredibly powerful and I still get chills when I hear it.

Bullet by Hollywood undead

Hard Times - Paramore first thing I thought of

It's a little more than kind of depressing but Bullet by Hollywood Undead comes to mind.

No Sunlight - Death Cab for Cutie

When I was young
Lying in the grass
I felt so safe
In a warming bath
Of sunlight, of sunlight
The vast open sky
Could do no harm
Like an embrace
Of a mother's arms
In sunlight, in sunlight
In sunlight, in sunlight
With every year
That came to pass
More clouds appeared
'Til the sky went black
And there was no sunlight, no sunlight
And there was no sunlight, no sunlight anymore
And it disappeared at the same speed
As the idealistic things I believed
When the optimist died inside of me
No sunlight, no sunlight
No sunlight, no sunlight
It disappeared at the same speed
As the idealistic things I believed
When the optimist died inside of me
No sunlight, no sunlight
No sunlight, no sunlight
No sunlight, no sunlight
No sunlight, no sunlight
No sunlight anymore

A good chunk of They Might Be Giants' discography.

Homeless Bleak Despair is about what's in the title.

Don't Let's Start "Everybody dies frustrated and sad and that is beautiful"

My Man is about being paralyzed.

That just scratches the surface.

I always found The Scientist by Coldplay to be a pretty upbeat song about the death of a loved one. And Viva la Vida upbeat, and all about the fall from grace.

Has anybody mentioned Joy Division yet?