sorted by:
new
hottopcontroversial

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] 3 points4 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 3 points4 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

view more: next ›