zkrni d2yrf yr2bi 762s8 e5yts bkiz2 4haez ihi73 sredt s9kds iih76 48fby 65579 ref3b 8ftdk aykn3 539by 56ta8 b6373 3i78a 96fs9 Formula for counting 2 names in a row 5 wide |

Formula for counting 2 names in a row 5 wide

2022.01.29 01:32 Jeremypwnz Formula for counting 2 names in a row 5 wide

Copy of my Sheet
So my group of friends and I play League of Legends and we play good amount of custom 10s and we've somewhat recently (July 2021) started keeping track of wins/losses of everyone. We're competitive so it's all about the bragging rights.
I'm trying to set it up so that we can see more in-depth data: how many times has A played with B, winrate together, and on each side of the map (blue vs red side), and winrate against.
But lets focus on the first one, which I'm being stumped by (how many times has A played with B), where I think I have the right formula but it doesn't seem to be working as expected. What I expected the equation to do is check the range and count how many times both names have shown up.
Location wise in the sheet, equations are in tab "Winrates", C12:C31 and F12:F31, the data itself is on the tab "Main", E27:I and J27:N (Blue and Red side)
What I'm doing is using the COUNTIFS function with the following equation below. I'm trying to set it up so I can drag and copy it for a table. B3 being the person's data I'm trying to look at. B12-31 being all the players I'm trying to get duo data for. What the equation is doing is counting only if both names are matching, essentially turning it into a COUNTIF.

=Countifs(Main!$E$27:$I, $B$3, Main!$E$27:$I, $B12) 
So in the end I'm pretty sure I'm just using the wrong function but I don't know where to go from here. I've been googling and searching Reddit trying to find the right way to do this but I'm coming up empty.
submitted by Jeremypwnz to googlesheets [link] [comments]


2022.01.29 01:32 above_gravity What car option you paid extra for and never used?

submitted by above_gravity to Porsche [link] [comments]


2022.01.29 01:32 irenehehe one of my favorite journal spreads hehe

one of my favorite journal spreads hehe submitted by irenehehe to Journaling [link] [comments]


2022.01.29 01:32 crytoloover GPX MAIN DI NIMO GALA, OURA BILANG INI GAME KAMI GA MUNGKIN KITA KALAH BILANG KE TIM BANG PEN PART 1

GPX MAIN DI NIMO GALA, OURA BILANG INI GAME KAMI GA MUNGKIN KITA KALAH BILANG KE TIM BANG PEN PART 1 submitted by crytoloover to coinmarketbag [link] [comments]


2022.01.29 01:32 catnie To wake or not to wake sleeping baby for feeding

I am a FTM to a preemie born 35+1 week. He is currently 1month and 2 weeks old chronologically or almost 2 weeks old adjusted. My husband and I are gearing up for when he goes back to work. I will be taking over night duty from when hubby is sleeping to the end of his work day. This is going to be 11pm -4pm.
I am having trouble deciding how long kiddo should sleep between feed. For reference, he has allergy and is on a special formula. We do in demand feeding but when it's at night and he is sleeping, do we wake him up? If so, do we wake him every two, three or four hours? Husband is of the opinion that baby is growing and our feeding data indicated a positive growing trend, and that kiddo is taking enough feeds to sleep longer at night, that he will cry and wake me up to feed when he wants it. I am afraid I will accidentally starve our child. I will admit sleeping longer stretch of time is nice and great for my mental health. What do people do at night? Anyone with a preemie know if we should use adjusted or chronological age to gauge sleep time?
submitted by catnie to NewParents [link] [comments]


2022.01.29 01:32 pervysage19 Amazon Canada - G303 SE - $30 off

submitted by pervysage19 to MouseReview [link] [comments]


2022.01.29 01:32 CaptainDerwin What pellet smoker should I buy?

Looking for some advice. I have a masterbuilt electric smoker and looking to upgrade to a pellet grill or a gravity charcoal(brother bought one and loves it) and not sure what I really want. I am looking at either Green Mountain Ledge, Pitboss Sportsman 820 or the Weber Smoke Fire, just reading a lot of grease fires with the Weber and price is a bit higher.
submitted by CaptainDerwin to pelletgrills [link] [comments]


2022.01.29 01:32 Kaios_Con Oh my 😳

Oh my 😳 submitted by Kaios_Con to masterduel [link] [comments]


2022.01.29 01:32 flyfish6000 (IKTR)

(IKTR) submitted by flyfish6000 to HotGirlNextDoor [link] [comments]


2022.01.29 01:32 Fast_Ad_7236 Transformation - 022. Artist Ravil Galeokbarov .

Transformation - 022. Artist Ravil Galeokbarov . submitted by Fast_Ad_7236 to surrealism [link] [comments]


2022.01.29 01:32 LuisDMM A2 - Scale 1/4 -

submitted by LuisDMM to 3DPrintingSTLs [link] [comments]


2022.01.29 01:32 frogfucker6942069 What is the funniest name you have ever run into on the rim?

I got a vye brator at one point, I checked, it is completely natural to the game. Thanks, tynan
submitted by frogfucker6942069 to RimWorld [link] [comments]


2022.01.29 01:32 JohnBrownsAngryBalls Bill to legalize marijuana in Ohio heads to lawmakers after hitting signature requirements

submitted by JohnBrownsAngryBalls to AkronOH [link] [comments]


2022.01.29 01:32 torontoballer Legit Check! Buying from local seller, please provide opinions, thanks!

Legit Check! Buying from local seller, please provide opinions, thanks! submitted by torontoballer to WarrenLotas [link] [comments]


2022.01.29 01:32 draztico Are the T2 novels linked to the Sarah Conners Chronicles? Or are they separate stories entirely?

Wanted to know out of curiosity. I am planning on reading/watching both.
Please and Thanks.
submitted by draztico to Terminator [link] [comments]


2022.01.29 01:32 throwaway009335 Made whole wheat pita bread, some on the cast iron and some in oven. Very easy, delicious and way cheaper than store bought!

Made whole wheat pita bread, some on the cast iron and some in oven. Very easy, delicious and way cheaper than store bought! submitted by throwaway009335 to EatCheapAndHealthy [link] [comments]


2022.01.29 01:32 HovercraftNext99 MACKAVON - Clueless [Emo Rap]

MACKAVON - Clueless [Emo Rap] submitted by HovercraftNext99 to SpotifyHub [link] [comments]


2022.01.29 01:32 Legitimate_Vast_3271 When Clinton Lied, Yugoslavia Died

Here's another masacure sponsored by the Clinton crime family.
"When former Yugoslavian President Slobodan Milosevic died on March 11, the mass media renewed its demonization of Milosevic and its deliberate distortion of the truth about NATO's attack against Yugoslavia. Using the false pretext of "humanitarian intervention," NATO forces led by the U.S. under the command of General Wesley Clark committed the worst war crimes in the Yugoslavian conflict that climaxed with NATO's 78 day aerial bombardment of civilian targets in Serbia and Kosovo in 1999. Serbians were more often the victims of "ethnic cleansing" by U.S. allies, rather than its perpetrators."
ARTICLE
submitted by Legitimate_Vast_3271 to conspiracy_commons [link] [comments]


2022.01.29 01:32 mrAAAAAAAAAAAAAAAAAA Subreddit for perfectly cut game theories

submitted by mrAAAAAAAAAAAAAAAAAA to findareddit [link] [comments]


2022.01.29 01:32 cardibclosett IM SORRYTE THEYRE COLD

submitted by cardibclosett to teenagersnew [link] [comments]


2022.01.29 01:32 creepy_cactus28 How do i propagate this buddy? its growing too long.

submitted by creepy_cactus28 to cactus [link] [comments]


2022.01.29 01:32 uniqueandweird I just watched the whole series today after my sister recommended it for so long and while it infuriated me at times I'm not surprised the "Sicklers" pretty much got away with it.

Big pharmaceutical companies and others like it can buy their way out of way too much. As a sidenote if you're sceptical of any company check if they have subsidiary companies or similar products under a different name. Nestle has proven itself to be shady so see what other companies fall under their umbrella so you know which other products or services to avoid.
Back to the "Sicklers". They are absolutely devoid of any morals or ethics. How could they be caring, kind or thoughtful when they deceived everyone from the beginning with false information about Oxycontin? It's always been about money and greed with them. How could their lawyers lose their backbone that much that they'd defend them in the first place? I'm sure everyone involved with the "Sicklers" thinks they're so much better than everyone else but just like the "Sicklers" they're worth less than the dirt that their victims' shoes walked on.
submitted by uniqueandweird to dopesick [link] [comments]


2022.01.29 01:32 mswoodlander Just Finished Quilt

Just Finished Quilt I just made this for my great-nephew-to-be. I'm really happy with how it came out. I've stopped using batting for the most part, so this one is filled with a nice soft flannel. It's backed with satin to make it feel really soft.
https://preview.redd.it/1d3090so1ke81.jpg?width=960&format=pjpg&auto=webp&s=2384cba702373d4046c95fd89e2dd75aaa3a9f67
submitted by mswoodlander to quilting [link] [comments]


2022.01.29 01:31 Marco_808 anyone get their LOAD merch refunded i was wanting to get my flocky flocky tee in hand so bad shit sucks /:

submitted by Marco_808 to DonToliver [link] [comments]


2022.01.29 01:31 Professional-Data617 Huntington ave is so scary for biking

Is it just me or does anyone else here feels that Huntington ave near Northeastern is absolutely scary for biking? Especially the route near Panera Bread/Gong cha running parallel to Northeastern. So many cars are parked on the right and sometimes they randomly open their doors and it's too scary. You share the lane with cars and then most of the right side is occupied by the cars parked there :( People who bike along this route, what precautions do you usually take?
submitted by Professional-Data617 to bikeboston [link] [comments]


http://voda-vek.ru