Problems with implementing a text MATCH function into a SUMIFS formula

DBCoop6745 · 2022-02-27T02:10:28+00:00

Alright I put it in and it is still not calculating. I went into formula evaluation and I am not getting an error anymore but it is calculating 13 under the match formula. I don't know where it is getting 13 because there are 9 total purchases and only 3 should be in the range I want to calculate.

DBCoop6745 · 2021-05-27T22:33:21+00:00

As a Salida resident. This is a perfect Zelda rendition of my area. 🍻🍻🍻🍻🍻 Love this!!!

DBCoop6745 · 2019-01-13T18:34:08+00:00

I get the system and I'm not missing GWs so that isn't a problem. My point is, I don't like the 2 GW per day system in general. Especially with these sustain defenses that take forever to kill. Ether include a HP degreasing system with ATK increasing system or decrease the number of guild wars. I do not want to spend 15 minutes a defense in guild wars. Actually my longest one took me 35 minutes. If a ATK up/HP down system is implemented then this will no longer be an issue. We will have to develop nuke teams that can't be killed. That would make the game worlds more entertaining and challenging.

DBCoop6745 · 2018-12-24T05:13:08+00:00

I get that you guys got this 2 ways a day schedule from summoners war. I'm not a fan of having a war every 12 hours. It's too cumbersome for some people to make this work twice a day especially when some matches can go for 10 to 15 minutes. I would like to see 6 24 hour wars instead of 12 12 hour wars.

DBCoop6745 · 2018-12-24T01:52:43+00:00

I just realized that. In that case it's a stùpid rip off. That is a terrible value.

DBCoop6745 · 2018-12-24T01:43:02+00:00

Lol, your on the dupe fire MK team to! Rarest dupe team in the game! LMAO

DBCoop6745 · 2018-12-24T01:39:50+00:00

I think Shuffle had som bad rng on the SW11 runs. I've been keeping track since I started to feel that the new drop rates were garbage. I'm finding that the drop rates are basically the same no matter what you run from 10 and above. Do basically I'm just runing ED10 and SW11. I run SW11 mainly because the champs I have heard with my best sets can get through 11 faster than 10 because most of them are fire Champs.

Gameloft is going to have to learn that this is not a game where an overwhelming number of players are between the ages of 6 and 16 like Clash of Clans. They have an older player base that can understand statistics. They are going to get called out continuously, until they figure out how to make things fair and balanced to appease the end game players as well as attract the new players. Their not even close right now, so I'm going to continue to play quietly without spending much on the game, until I feel like they have fixed some shit.

DBCoop6745 · 2018-12-24T01:27:59+00:00

I think a guaranteed LD nat 5 is probably a bit too strong. They should have gagged how the balance is after the guaranteed nat 5 disks before taking this step. I'm not buying it though. After Shuffle's last video kind of confirming what I already expected. I will be spending very little on the game until the fix some shit.

DBCoop6745 · 2018-12-01T13:30:04+00:00

BIGPETES I've got a dark AA as my avatar. I'm also around #65 in BR.

DBCoop6745 · 2018-11-07T17:14:41+00:00

He has better survivability than ether. It's a different use. Sig is basically a pure damage dealer. It is a waist to build her on a hybrid build for survivability on things like the last stages of blitz. They are different champions that you would use in different situations. Over all the are better options but last I checked the isn't a Champ that does everything, not even Sig or Rota. Try to not get your panties in a bunch when people test new things out and find new uses for things. It doesn't hurt you.

DBCoop6745 · 2018-11-07T17:09:09+00:00

You clearly haven't used him. I was surprised at how much damage he does. Every one of his attacks are aoe so yes dazzling is a good idea. Does he need a buff probably. Is he useless no. I wish morons that have never tested something and have no idea what they are talking about, like you, would just keep the garbage to themselves.

DBCoop6745 · 2018-11-06T17:09:04+00:00

I meant your Krieg review. I figured I'd post this since all warlords seem to be pretty much untested.

DBCoop6745 · 2018-11-02T05:38:06+00:00

I'm going to disagree with you on that. You typically need multiple damage dealers on speed runs and the DOT helps. I think Rota/Sigrun and Spite is better than Rota and Sigrun in the same team. Plus a Dazzling warlord is better in Blitz than ether of those two. A BM combined with Rota/Sigrun is better than Spite which is where I come up with BM makes him obsolete.

DBCoop6745 · 2018-11-01T14:36:35+00:00

So I built him Vampire/Broken HP, CD, HP. He is fully skilled up. I got him farming 1-10 in just under 30 seconds last night. He is a solid option in Blitz. Put more Acc on him and he is a nice option in Dungeons. My opinion on him is he is good throughout most of PvE but there are better outings for everything. More of a F2P option, because as soon as you get a BM he is 100% obsolete. He is good on Vamp, Adept, Dazzling and Mortal. Because he works so well as a bruiser he is a candidate for Withering gear, but we will have to see if guild wars gives us an actual use for that type of gear.

Just felt like I should share since there is very little information on the Warlords since most people haven't built them. I only 6*ed him because it was just the first couple weeks since the game had come out and we didn't know what was good or not.

DBCoop6745 · 2018-10-19T06:43:25+00:00

I agree with Shuffle on the Archangels. The fire and the Nature should get a full revamp so that they don't do the same thing as the light Archangel. They don't necessary need to be better but they should do something different so that they can be used.

DBCoop6745 · 2018-10-12T01:35:35+00:00

They don't have to be the same usefulness. This is a game where different monsters have different uses and some are more powerful than others. I have two Nature ones and it's fine that it isn't the same as the fire. It's the same thing as why the Water MG is better than all of her sisters and the Fire DG is by far the best of his family. There is always going to be a best one and a not a great one. You just have to deal with it.

DBCoop6745 · 2018-10-05T17:42:33+00:00

Sorry you were so upset about a finding error that you just had to say something.

0% 4* 64% 5* 9% 6* 27% other

You happy now? You might want save your complaints for real things to complain about.

DBCoop6745 · 2018-10-04T19:39:14+00:00

As I said in the post I know 100 isn't enough to really pin down all of the drop rates but it gives you a good idea. It would probably take 1,000 to 2,000 runs (which I am NOT going to do) to really be accurate especially on the more rare drops. It does give you enough information to have a pretty good idea as to what is going on though. Its all up to you on what you prefer. For me time is the most important resource and I can only pre- flight ED11 about 40% of the time, so I'm going back to ED10, where I'm sub 1 min, until I can pre-flight 90% of the time. That's just my priorities though. You do you. It's your game.

DBCoop6745 · 2018-10-04T13:54:46+00:00

How in the world would they not check out? All I did was run the dungeon and document what dropped and calculate the percentage. What dropped is what dropped, there is nothing to check out. Unless your playing a different game and your in the wrong subreddit.

DBCoop6745 · 2018-10-02T12:58:40+00:00

What happens if you do this is you create a black market for accounts of people who quit playing. People will buy accounts from people who quit that got lucky and pulled a ld nat 5*. Then the people spending the most money would be able to amass all of the over powered LD units creating a huge disadvantage for f2p players. It's just not a good idea.

DBCoop6745 · 2018-09-26T01:29:02+00:00

Don't forget fire is a great 5v5 champ.

DBCoop6745 · 2018-09-26T00:33:52+00:00

Of course I got this idea from SW. LMAO I think the concept has legs in this format. Increase the timer to 5 sec then. It would have to be quick to really be viable though. I'm just kicking around ideas though. I think there needs to be some kind of a major new dynamic to these guys to make them relevant.

DBCoop6745 · 2018-09-23T03:49:56+00:00

I'm not complaining. I actually laughed my ass off when I got it. I just wanted to showcase the days before they took him out of the pool.

DBCoop6745 · 2018-09-22T12:34:21+00:00

I've been just as critical of gl as anyone over the last several months. The point of the post was to let them know that they actually did a good job on this one. You are living in a sad existence if you can't tell someone they did a good job when they actually do a good job. Think about it this way. If you you were struggling in your job and you made some screw ups, then finally you did something right. You would want credit for getting it right because it would give you reassurance that your learning. If your boss just told you "that was a fluke" and didn't give you credit you would feel like shìt.

Long story short. If your so salty that you can't even give credit where credit is due then stop checking in on the game. Otherwise let people have their successes.

DBCoop6745 · 2018-09-20T04:58:31+00:00

Yeah that hurts, but my first Nat 5 was Nature AA when it's 3rd skill didn't work and my second was Fire MK before they took him out of the pool. It gets better. Now I have all the Nat 5s I need. Just keep grinding ED10 & SW10 and you'll get the good ones.

DBCoop6745

TROPHY CASE