Problem with using a variable for multiple conditions in SUMIF
2024.11.25 16:21 Glantin Problem with using a variable for multiple conditions in SUMIF
Hello everyone,
I’m getting crazy about this issue. If you can help, it will be much appreciated!
Here is my working formula :
=SUM(SUMIFS(Ventes!$K:$K, Ventes!$D:$D, {"100";"101";"104";"110";"111";"112"}, Ventes!$K:$K, ">0%", Ventes!$A:$A, $A20))
I want to sum my columns K for D = “100”, D = “101”… I want to put my filters in a cell as they will often change so for example C2 = {"100";"101";"104";"110";"111";"112"}
So in essence, I would like to do : =SUM(SUMIFS(Ventes!$K:$K, Ventes!$D:$D, C2, Ventes!$K:$K, ">0%", Ventes!$A:$A, $A20)) But I can’t get it to work, I’ve tried using INDIRECT and ChatGPT and google can’t find a solution.
Thank you in advance for your help !
submitted by Glantin to excel [link] [comments]
2024.11.25 16:21 djpolofish Donald Trump’s return sends shivers through the anti-misinformation world
submitted by djpolofish to InternationalNews [link] [comments]
2024.11.25 16:21 syphilisrolls Academic Upgrading
I’m currently in Pre-Service Fire as I did not get into paramedics straight out of high school, and I’m realizing that it is probably not the best way to better my chances of getting into paramedics as my high school grades weren’t the best. I struggled with hypersomnia in my grade 11 and grade 12 years, and I slept through most of my period one classes. I took period one spares in grade 12 which helped a lot, but I slept through most of grade 11 chem which ended up with me getting a 55 in the course. My bio grades were 92 in grade 11 and 90 in grade 12 which I think will be okay. What’s the best and fastest way for me to upgrade this mark? I’m looking at virtual schools (OVS, Canada E School) primarily as I feel they will be the fastest, but if there are better options I’m willing to hear them.
submitted by syphilisrolls to OntarioParamedics [link] [comments]
2024.11.25 16:21 thebirdhouseinursoul in college, planning to be a housewife
i’m struggling a lot with motivation. any advice?
submitted by thebirdhouseinursoul to housewifery [link] [comments]
2024.11.25 16:21 Terrible_Seaweed_980 Hint today
Anyone know what the two books are that were unwrapped in the feed today?
submitted by Terrible_Seaweed_980 to bookofthemonthclub [link] [comments]
2024.11.25 16:21 gayforsmoshwomen they're too cute!!
 | i love seeing my wives together outside the office (posting this here cause it gets removed in the smosh subreddit for some reason) submitted by gayforsmoshwomen to Smoshmemes [link] [comments] |
2024.11.25 16:21 ThePaleThing Seems I "make no sense"
Link to test: https://hitostat.com/tests/cognitive-functions-test/
submitted by ThePaleThing to MbtiTypeMe [link] [comments]
2024.11.25 16:21 Full-Mulberry5018 This Cute Kajla Lamb 🐑
submitted by Full-Mulberry5018 to cuteanimals [link] [comments]
2024.11.25 16:21 cop1152 It was bound to happen sooner or later. My office is switching to smart dumpsters...or Which one of ya'll did this?
 | submitted by cop1152 to funny [link] [comments] |
2024.11.25 16:21 MaterialAgent4105 Why just not make a Whattsapp group ?
Seeing posts for wanting to make friends and socialize, let's make a Whattsapp group and randomly go on physical meet of four and six ? If we click well and good if not it wasn't meant to be
Anyone in ??
submitted by MaterialAgent4105 to Bengaluru [link] [comments]
2024.11.25 16:21 Global-Package-9856 Lego 42038 snow groomer
Does anyone know where I can find the instructions for this MOC?
submitted by Global-Package-9856 to lego [link] [comments]
2024.11.25 16:21 AI-is-4-StupidPeople Happy 10 year anniversary
Clouds have already started clearing . Blue Skies coming in 2025.
This anniversary commercial beautifully summarizes what this company is about and how it differs from all others with a complete ecosystem towards being the best in the EV industry . Focus on Quality and clean minimalist, user centric design and not quantity will make NIO the most desirable and profitable EV company in the very near future.
Path to $100 share price is well established!
https://youtu.be/-_D4t2VYfZc?si=No5ZHnfiyOJT-z4H
submitted by AI-is-4-StupidPeople to Nio [link] [comments]
2024.11.25 16:21 TheYaoiEmpire The Vampire Scriptures: Nyxhaven 18+ Rp
18+ ONLY
ONLY JOIN IF YOU ARE SERIOUS ABOUT PARTICIPATING. There are trigger warnings in the rules, read them before deciding if you want to continue, if it's too much for you I request you leave without saying anything. Don't waste my or your time by pretending to be interested. You don't need to have read Lost Souls by Poppy Z Brite, but understanding the tone of that book will help you understand the tone of my book and rp universe. If you understand that tone, you'll understand the groundwork for The Vampire Scriptures.
CURRENT EVENT: THE DESTRUCTION OF COCKROACH'S HIDEY HOLE! WAR BETWEEN THE HOCUL WITCHES AND SPECTRI VAMPIRES IS ON THE HORIZON!
There is a lot of lore and information but don't be discouraged we are here to help.
Join The Vampire Scriptures: Nyxhaven RP Discord Server!
Welcome to Nyxhaven, where the night is alive with intrigue, seduction, and danger. Step into a world filled with vampires, elves, witches, and mutants, all navigating a realm steeped in hedonism and mysterious desire.
An updated power system for Spectri vampires similar to domain expansions and stands!
NSFW SERVER, MATURE THEMES, ADULTS ONLY.
This universe is inspired by the works of Poppy Z. Brite
Welcome to Nyxhaven, a dark city where the undead rule from the shadows, bound by ancient laws known as The Vampire Scriptures. Behind its vibrant nightlife and alluring mysteries, Nyxhaven is a world of indulgence, secrecy, and danger, where vampires carefully balance their power while concealing their existence from the mortal world.
Lore Overview: In Nyxhaven, vampires exist unseen by humans, guided by The Vampire Scriptures that enforce strict secrecy. These laws dictate that humans can only learn of the undead when their death is imminent. Vampires here do not breathe, their hearts do not beat, and they possess no warmth. They have mastered illusions to pass as human and interact in plain sight, their true nature remaining hidden.
Setting: Nyxhaven thrives in the night, its dark alleys and lavish establishments providing a perfect backdrop for vampire life. Here, influential figures mingle with the unaware, and secrets are currency. The city’s most prominent locations reveal both its hedonistic allure and its deadly dangers.
Key Locations: - Club Bitter Blood: A high-end nightclub owned by Nixxy Havok an omega with a sarcastic flair, Club Bitter Blood serves as a decadent playground for the powerful and their loyal followers. It’s a hotspot for intrigue, indulgence, and occasional bloodletting, where humans are drawn to the thrill and vampires can hunt behind a thin veil of glamour. - Cafe Lace Moon: A cozy café run by Fifi, an uptight omega vampire with midnight blue hair and a knack for making delicious blood-infused pastries even with his sour attitude. The café’s soft lighting and delicate lace décor provide a relaxed atmosphere where vampires can take a break from their scheming and humans can unknowingly rub shoulders with predators. - The Diner of Eternal Nights: An old-school diner owned by Bubbles and Still, the fifth oldest vampire in Nyxhaven, affectionately called "Grandpápá Still" by the city’s vampire population. The diner is not neutral ground; it’s a sanctuary for vampires only, where hunters are strictly forbidden. Known for its retro charm, the diner is a hub of gossip and information, thanks to Still’s vast knowledge and connections. If you want to learn the city’s darkest secrets, you speak to Grandpápá Still, but beware, he doesn’t give away information for free. - HOLY HOLY HOLY! Headquarters: A well-guarded location serving as the hidden base of Nyxhaven’s dedicated vampire hunters. They operate covertly, equipped with ancient relics and forbidden knowledge in their mission to cleanse the city of its undead.
Roleplay Themes & Opportunities: - Seduction & Power: Vampires wield their charm to dominate or seduce others, blurring the lines between predator and partner. Characters must balance their desires with the need to protect their secrets. - Intrigue & Betrayal: Nyxhaven thrives on alliances and hidden rivalries, where trust is rare and betrayal can lead to deadly consequences. - Forbidden Romance & Taboos: Relationships are dangerous in Nyxhaven. From vampire-human bonds to struggles with the Curse of Humanity, characters must navigate passion while facing their own vulnerabilities. - Secrets & Manipulation: Nyxhaven’s vampires trade in secrets. Characters can attempt to gain power by exploiting what they know or choosing to remain in the shadows.
Server Features: - Story-Driven Events: Regularly planned events push the narrative forward, focusing on coven rivalries, vampire hunts, and high-stakes drama at key locations like Club Bitter Blood or The Diner of Eternal Nights. - Expansive Lore: A comprehensive guide to the world of Nyxhaven, with details on its laws, notable characters, and significant locations to inspire immersive storytelling.
More of What We Offer: - Dynamic Storytelling: Engage in immersive roleplay within a rich, expansive lore. Create your own narrative while interacting with others as you explore the intricacies of Nyxhaven. - Unique Species & Clans: Choose from a variety of factions, including the enigmatic Spectri male vampires, the haughty Elyndra female elves, and the powerful Celestia female vampires. Form alliances, betray rivals, or build your own coven! - Character Development: Craft complex characters with diverse backgrounds and motivations. Explore themes of seduction, power struggles, and forbidden romances as you delve into Nyxhaven’s secrets. - Regular Events & Plot Twists: Participate in server-wide events that push the narrative forward. From vampire hunts to coven rivalries, experience thrilling moments that will keep you on your toes! - Community & Collaboration: Connect with like-minded individuals who share your passion for storytelling. Work together to create captivating plots or engage in friendly rivalries.
Key Features: - Archetype Clans: Choose from 16 distinct clans, each with its own culture, customs, and hierarchies. - Player-Led Storylines: Influence the future of Nyxhaven through your actions. Your choices matter! - Custom Lore & Rules: Dive deep into a comprehensive guide detailing the laws and lore of Nyxhaven.
Enter a World of Shadows: Will you rise to power, succumb to the curse of humanity, or expose the darkness lurking beneath the city’s surface? Your fate awaits in Nyxhaven.
🔗 Join Nyxhaven Now! [https://discord.gg/JuEP4KKPgm ]
Embrace the night. Unleash your desires. Welcome to The Vampire Scriptures: Nyxhaven!
submitted by TheYaoiEmpire to DiscordAdvertising [link] [comments]
2024.11.25 16:21 HaterdeXbox Voltando a procrastinação da CLT
 | Voltei com mais um desenho que fiz no serviço, esse foi mais demorado, mas oq vcs acham? Tem dicas do próximo? submitted by HaterdeXbox to desenhos [link] [comments] |
2024.11.25 16:21 VisualMeringue4986 PPD kicking my A$$
Background: hubby is a law student and is gone during the day and is studying all evening at home, with breaks to tend to our 8month old.
I fucking hate it here. I cry 20 times a day and I feel so lonely. Who tf said being a mom was a gift? This shit fucking sucks and I am trying to do my part while my husband does his in school. Idk I’m just venting. I love my baby so much and I wish I can rid these bad feelings. Today I yelled at him😢 he definitely didn’t deserve that and I won’t be doing it again.
submitted by VisualMeringue4986 to Postpartum_Depression [link] [comments]
2024.11.25 16:21 Jess-M-86 Passport office wait time
Has anyone waited in line for a passport recently or have any idea what the wait times are like?
Thanks!
submitted by Jess-M-86 to saskatoon [link] [comments]
2024.11.25 16:21 WoodpeckerObvious818 MORE SURPRISING THAN DSP NO RTM
 | submitted by WoodpeckerObvious818 to CricketShitpost [link] [comments] |
2024.11.25 16:21 Significant-Tea7556 TPR Hearing Faster than Expected?
We have had our FD for 6 months and the judge just scheduled a tentative TPR hearing in the spring. DSS and GAL asked us if we are willing to adopt her and we’ve said yes, but this timeline feels so much quicker than we’d originally been told. Should we expect that this will actually be a more drawn out process and the spring date is just the start?
submitted by Significant-Tea7556 to Fosterparents [link] [comments]
2024.11.25 16:21 WorriedAd870 Axie Infinity Creator Cuts Jobs but Promises a Bold Comeback
 | submitted by WorriedAd870 to MobileGaming [link] [comments] |
2024.11.25 16:21 NorthCompetition4334 Next KM Album?
They only seem to release singles, was wondering when would the next Album drop? Something that takes you on a journey instead of the usual trend of milking unreleased singles and then dropping them officially a year and a half later.
Sénd return and you are safe honestly took me on a journey and I wish there were more albums :/
submitted by NorthCompetition4334 to kloudmusik [link] [comments]
2024.11.25 16:21 BobLI Deuterocohnia brevifolia university specimen
submitted by BobLI to bromeliad [link] [comments]
2024.11.25 16:21 7HLow Which VW classic is easier to run and own based on cost to restore and is there various factors? A Bus (T2 Panel) or a Pre-67 bug?
 | Beginner here, pretty tempting to get a classic vw as a restoration project but Im curious which of these these are much beginner friendly to be a resto project and Im drawn between a T2 panel van (T1 panel if we’re stretching it) and a pre 67 Bug. I did thought about having it as a project and I do have a normal car as my daily. Pardon me as Im still rather new when it comes to VW classics and I do appreciate the feedback and insights submitted by 7HLow to Volkswagen [link] [comments] |
2024.11.25 16:21 Chocolate13435 Selling double red trait aeries (Weight+damage) Best offer so far: 5k and a glow tail mutation.NYP
 | submitted by Chocolate13435 to CreaturesofSonaria [link] [comments] |
2024.11.25 16:21 Morcalvin Is there a mod that lets you grow crystals like amethyst or corundum?
I’m using mine colonies and one of the buildings in my colony requires over 600 blocks of amethyst, another requires corundum clusters. Surely there’s a mod somewhere that’d let me grow them in like a crystalarium or something like that?
submitted by Morcalvin to ModdedMinecraft [link] [comments]
2024.11.25 16:21 Burnt_dino Is there any other really skinny male teens out here
I'm asking because I don't wanna feel alone 😞🙁. I feel like my body is really weird and unnatural, I'm a 15 year old male but everyone else seems to be bulked up or have SOME meat on their bones and I end up feeling really insecure and left out. I've seen kids 8 year old with more meat on their arms and legs than me and I feel so ugly and insecure because of that. I try my best to not compare myself to other boys but it's hard when they have everything you want on YOUR BODY. DONT SAY TO EAT MORE BECAUSE I EAT WHAT MY PARENTS CAN AFFORD BECAUSE MONEY HAS BEEN TOUGH FOR US LIKE A YEAR, and I tried to solve my skinniest but working but it's been months (7 months specifically) and no progress like AT ALL. I just feel so weak compared to the other boys and I feel like their better than me😞😞☹️🫤. Im so unconfident with myself because of my skinny disgusting ass body ☹️☹️. Also my voice is high pitched asf so I feel EVEN more insecure about my body and it's sounds REALLY GAY FOR LIKE NO REASON. I just feel like my body isn't developing like the other boys because their voices and muscles have started to come in while I look like a 7 year old WHEN IM 15 TURNING 16 JANUARY?! it's not fair I was born this way, why isn't my body perfect like the others😞🙁. I feel so disappointed everytime I see it.
submitted by Burnt_dino to teenagers [link] [comments]