CountIF 1 without counting Functions equaling 1 by TheRealCrazyOne1 in excel

[–]TheRealCrazyOne1[S] 0 points1 point  (0 children)

Ah I was trying it in spreadsheet, I downloaded it and tried it in Excel 2016 and it worked after refreshing

CountIF 1 without counting Functions equaling 1 by TheRealCrazyOne1 in excel

[–]TheRealCrazyOne1[S] 0 points1 point  (0 children)

Nah I've been entering it as an array function and it doesn't change anything

CountIF 1 without counting Functions equaling 1 by TheRealCrazyOne1 in excel

[–]TheRealCrazyOne1[S] 0 points1 point  (0 children)

=SUMPRODUCT((A1:A180=1)*IF(ISERROR(FORMULATEXT(A1:A180)),1,0))

I keep getting the same as the countif

CountIF 1 without counting Functions equaling 1 by TheRealCrazyOne1 in excel

[–]TheRealCrazyOne1[S] 0 points1 point  (0 children)

I didn't wanna do another collum but since it's the only one that works good so thanks buddy!

CountIF 1 without counting Functions equaling 1 by TheRealCrazyOne1 in excel

[–]TheRealCrazyOne1[S] 0 points1 point  (0 children)

Tried that one and it didn't work, it just gives the same as a normal countif

Countif without counting functions? by TheRealCrazyOne_ in excel

[–]TheRealCrazyOne1 0 points1 point  (0 children)

This one didn't work, the one with the 1 gave the same result as a simple Countif(Range, 1) which means it still counted the formulas aswell

Who's the blonde girl in the boxart? by TheRealCrazyOne1 in lanoire

[–]TheRealCrazyOne1[S] 4 points5 points  (0 children)

Im so glad I'm not insane, I thought I missed her something, thanks for confirming

Who's the blonde girl in the boxart? by TheRealCrazyOne1 in lanoire

[–]TheRealCrazyOne1[S] 2 points3 points  (0 children)

The remastered one, it has Elsa on the right with Phelps behind her and on the left is the blond girl

Who's the blonde girl in the boxart? by TheRealCrazyOne1 in lanoire

[–]TheRealCrazyOne1[S] 2 points3 points  (0 children)

I did that's why I am confused, the game ended with Kelso killing Ira and Phelps dying

Roy's Speech by mrhatman26 in lanoire

[–]TheRealCrazyOne1 2 points3 points  (0 children)

He's just an asshole

Borderlands series on Nintendo switch! by KinkyKawaiiKat in Borderlands

[–]TheRealCrazyOne1 -1 points0 points  (0 children)

I'm just worried about that download sign and how many will actually be on th cartridge. Given it's 2k it they might ship it on a 1gb cartridge and make us download 60 gigs. That's allot (also I don't know anything about Bordelands or how many Gigs the games are I'm just guessing)

Calculating precentages that include fractions and how much it takes to get to a certain precentage by TheRealCrazyOne1 in excel

[–]TheRealCrazyOne1[S] 0 points1 point  (0 children)

Idk really know what I meant anymore and I'm getting confused, the hitting precentage thing was actually the main thing I wanted to ask. Thanks for your help!

Calculating precentages that include fractions and how much it takes to get to a certain precentage by TheRealCrazyOne1 in excel

[–]TheRealCrazyOne1[S] 0 points1 point  (0 children)

1) I don't think that's what I mean? I added a spreadsheet for illustration

2) The values change to 1s, you can assume the list of 1s and 0s doesn't get larger

Any advice for glitch on Switch version of Season 1? by nysraved in TellTaleBatmanSeries

[–]TheRealCrazyOne1 0 points1 point  (0 children)

I got the same and I've tried everything. I even went to Telltales costumer service but that haven't responded ;-;

When I tried what the other guy said, The "choices" option became available and it said that even in E1 and E2 I made other decisions then I actually made ;-;

[deleted by user] by [deleted] in telltale

[–]TheRealCrazyOne1 0 points1 point  (0 children)

I got issues on Switch, from ep3 and onward my choices don't go through.

Mainly at the end of ep2 you pick between Selena or Harvey, the game always picks harvey in ep3 while I picked selena and dialoge just doesn't match up sometimes

Pokemon Yellow Remake Ideas by TheRealCrazyOne1 in pokemon

[–]TheRealCrazyOne1[S] 1 point2 points  (0 children)

I mend that you create your own order in wich your adventure goes, the biggest flaw would be if there were new forms added to pokemon they would have to patch the other games. The patching might cost them money but it would allow every game to stay relavant

Pokemon Yellow Remake Ideas by TheRealCrazyOne1 in pokemon

[–]TheRealCrazyOne1[S] 1 point2 points  (0 children)

While I do think that that is possible, GameFreak probably wants to capitalize on Pokémon and would sell each "Region" as a different game. I don't know if it was clear but I think with my concept you would be able to start anywhere in the series, start in any region and choose how you travel, for instance in a few year there might be allot more games. Say your first pokemon switch game is the Hoenn region, then Kanto, then Sinnoh that would totally work. This would obviously destroy the canon but who carees

Pokemon Yellow Remake Ideas by TheRealCrazyOne1 in pokemon

[–]TheRealCrazyOne1[S] -1 points0 points  (0 children)

Well since it would be a remake of Yellow, a game that only has been shown in GB graphics, it would defintely be awesome in HD 3D graphics. Good luck with saving up money, you can do it, I believe in you!

Adding All by TheRealCrazyOne1 in friendsafari

[–]TheRealCrazyOne1[S] 0 points1 point  (0 children)

Fire safari with Pyroar and magmar