Excel Countif Cell Is Not Blank

[ The Fiction Awards 2019 Winner ••• Best Of Lgbt ] Steven turned back around and was headed to his room, he unlocked the door and went inside, just as he was about closing the door, he felt a push and David stepped into the room and clicked the door locked. Eyes back on Steven's like a predator about to pounce on its prey, one painful yet slow step and another he took, while the other stepped back until he was pressed against the wall. With no place to run to, Steven stopped. Eyes on David as he took his last step forward. "W-what are you doing?" "God, you're beautiful." "W-what." "I want to kiss you so badly that my heart burns from just the thoughts of it." "D-David." "Kiss me, Steven, please!" And kiss him he did... DAVID+STEVEN=BEST-FRIEND'S. DAVID IS MARRIED. STEVEN IS SINGLE. #BOY ROMANCE. WARNING: SAD ENDING.

Because of his handsomeness and perfection, Demitri always became the target of women. His charm was beyond reason, always making him feel like a magnet on Earth. Not only that, as he hadn't yet found a prospective partner, his parents often tried to arrange him with his colleagues. Not wanting to be forced into a match, Demitri, by chance, encountered a mentally unstable woman who claimed to be his lover and decided to take advantage of her. He made an offer to the girl to enter into a contract marriage with him, in order to escape from his mother's matchmaking. So, how did their story unfold? How long can they endure the lie they made so explicitly? Follow their journey, only in the novel "CEO NOT FOR SALE!"

The day of the verdict, Simon—my fiancé—begged me to take the deal. "I know you're innocent, but Nancy's pregnant. I can't let her go to jail." Tears. Fake concern. "This is for your own good," he said, holding my hand. I signed it. In my last life, I refused—and paid for it with prison, torture, and infertility. This time? I played along. By morning, headlines screamed I'd stolen trade secrets. Nancy? Front and center. "Yeah, it was her. I saw her sneak into Johnston Group with my own eyes!" But when court opened that afternoon, Clark—yes, the plaintiff—stepped up and dropped the case. Then, in front of everyone, he pulled out a ring, dropped to one knee, and said, "Heidi Wynn, this time... will you marry me?"

Charles Dickson will transfer five million dollars to me every time he cheats. After three years of being together, I've saved enough money to last a lifetime. This time, he transfers ten million dollars to me. I immediately pack my things and make a run for it when I see the money in my account. By the time he tracks me down, I've started a career as a teacher. He looks disdainful. "Enough of this nonsense. What can you teach them?" I run my mouth. "I'm using my experience to teach young women how to find a rich, generous husband who's always away from home, of course!" That strikes a nerve. His eyes turn red with rage as he snaps, "Am I nothing but a teaching tool to you, Chloe?" "Of course not!" I say. Before he can feel pleased, I continue, "At most, you're a failed specimen because you always come home…"

When nineteen-year-old engineering student Sky is scouted by Dream Entertainment, he thinks it’s a scam—until life throws him into financial uncertainty and he decides to take the leap. What starts as a desperate attempt to help his family quickly evolves into something far more complicated: a chance to star in a reality show where contestants pair up and compete for a coveted lead role in a new Boys’ Love (BL) series. Night, a successful but emotionally guarded model, isn’t the type to sign on for flashy reality shows—until he sees Sky’s casting photo and feels something he can’t explain. Against his manager’s advice and his own better judgment, he joins the project, drawn to the boy with the shy smile and uncertain eyes. Thrown into a house with six striking and wildly different contestants, Sky and Night are assigned roommates—others, not each other—and must navigate awkward first impressions, lip-sync battles, late-night conversations, and the growing tension between competition and connection. As the cameras roll and emotions blur, the question that hanging in the air: Is this just a path to fame in the entertainment industry—or is it something real? Is it all just for show?

I died with blood on my hands and betrayal in my heart. My husband didn't love me. My sister didn't respect me. And when I tried to expose them, they let me fall straight into a shattered glass table that ended my life. But I woke up a year earlier, with my voice restored and a second chance I didn't ask for. This time, I won't be the silent, obedient girl they walked all over. This time, I'll play their game better than they ever could. And when a billionaire offers me a deal I can't refuse, a fake marriage in exchange for saving his empire, I take it. They think I'm still that broken, voiceless woman. They have no idea what's coming.

A week before the wedding, my fiancé, Luke Graham, announced that he needed to marry his first love, Mandy Lynch, before marrying me. “It’s because her mother passed away,” he explained, “and her dying wish was to see Mandy married to a good man. I’m just fulfilling an elder’s final request. Don’t overthink it.” But the company had already planned to launch the “True Love” jewelry line on the day of our grand wedding. Impatiently, he dismissed my concerns: “It’s just a few million. Does that compare to Mandy’s love for her mother? If you’re so eager to make those millions, go find someone else to marry.” Hearing his cold and heartless words, I understood everything. Without another word, I turned and dialled my family. “Brother, help me find a new groom.”

On the eve of my engagement banquet, news broke that my fiancé had fathered a child with his mistress, and it spread like wildfire. Before I could confront him, Jayden Ford brushed it off casually. "It was just an accident. Focus on organizing the engagement banquet first. Besides, your dad’s in the late stages of stomach cancer. Calling off the engagement now won’t do either family any good." That night, he skipped the banquet but posted a photo of a swaddled newborn on social media. When I video-called him, he was bottle-feeding the baby. "I’ve been busy taking care of the kid. You know how it is. Our family lineage has always been sparse and dwindling, and the child takes priority." He wiped milk from the baby’s mouth. "But don’t worry. Once he’s a month old, I’ll send him to the overseas. Just show up on holidays and pretend to be his mom. The title of Mrs. Ford will always be yours." I stared at the matching diamond ring on his finger and couldn’t help but laugh. "Jayden, this engagement is off." He scoffed, "You're really throwing a tantrum over something like this? Don’t be so childish." I hung up on him and called his father—Charles Ford—directly. "I heard you’re looking for a new wife? Why not consider me?" I ran a hand over my belly and smiled. "After all, I’ve got a naturally fertile body. I can give you as many sons as you want." So much for being the sole heir. I’ll make sure he has plenty of brothers to keep him company.

At the beginning of a new year, I stay at the hospital to take care of my mother-in-law on my own. My wife, Yelena Lipton, on the other hand, is on a vacation with her first love, Phillip Warren, in a tropical island overseas. Funnily enough, I'm the last one who finds out about her impending marriage with Phillip. When my mother-in-law hears about the news, her condition deteriorates to the point she gets sent into the treatment room immediately. I have to call Yelena over a dozen times for her to finally pick up the call. "Do you have a death wish or something? Why did you bombard me with calls? I'm in the middle of something right now, so leave me alone!" After that, Yelena ends the call. Since then, I keep failing to get in contact with her. During that time, my mother-in-law has passed away from the treatment failure. When I'm done organizing the funeral, I send Yelena a divorce agreement right away. "Have you gone nuts? It's just an announcement to cheer Phillip up! Are you seriously going to file a divorce from me?" After hearing Yelena's accusations, I reply calmly, "Mom's dead. I've already dealt with everything concerning her passing. You should come back and visit her grave."

As I was about to leave my brother’s restaurant, the female manager stopped me. "Miss, excuse me, but you haven’t paid your bill." I looked at the unfamiliar face and thought that she was probably new and didn’t recognize me, so I explained politely, "Just put it on the owner’s tab. He knows me." The manager shot me a disdainful look. "Miss, this is a Michelin three-star restaurant. We don’t let just anyone run up a tab." She handed me a printed bill. I glanced at it. Fifty thousand dollars for one meal. Three thousand for tableware maintenance, five thousand for exclusive air purification, ten thousand for a VIP mood-calming service fee, and a bunch of other ridiculous charges. I didn’t even know my brother’s place was such a scam. I couldn’t help but laugh in disbelief. "I’m the owner’s sister. If there’s a problem, tell him to talk to me at home." But she just wouldn’t drop it. "If you can’t afford it, stop acting like you can. And don’t act like you know Mr. White, either." I fired off a quick text to my secretary. 【Tell my brother to either fire this manager or I’m pulling my investment.】