Math/computer people: I have a column of positive and negative numbers in Excel. I want Excel to add all the positive numbers while ignoring the negative ones. I don't know how to write a formula to do that, though. Is this possible in Excel?
Well, if we followed the recipe...should be cake. A demon-violence-free-zone cake.
Lorne ,'Why We Fight'
Natter 69: Practically names itself.
Off-topic discussion. Wanna talk about corsets, duct tape, or physics? This is the place. Detailed discussion of any current-season TV must be whitefonted.
Stephanie - Nov 22, 2011 7:45:21 am PST #7941 of 30001
Trust my rage
le nubian - Nov 22, 2011 8:15:01 am PST #7942 of 30001
"And to be clear, I am the hell. And the high water."
Stephanie, yes.
I would probably copy and paste them into a new column and sum the column
Column A has the numbers
Column B transforms Column A = IF(A2>0), A2,0)
Then Sum(B:B) to sum the column.
Burrell - Nov 22, 2011 8:46:23 am PST #7943 of 30001
Why did Darth Vader cross the road? To get to the Dark Side!
Jesse's really particular, Amy. It's weird.
But it's the Heartbreaking Tearjerker of the Day!?! Very sad.
Jesse - Nov 22, 2011 8:47:34 am PST #7944 of 30001
Sometimes I trip on how happy we could be.
Heartbreaking! Tearjerker!
Sophia Brooks - Nov 22, 2011 8:58:50 am PST #7945 of 30001
Cats to become a rabbit should gather immediately now here
That Heartbreaking Tearjerker ranks right up there with Jurassic Bark. I cried.
Tom Scola - Nov 22, 2011 8:59:58 am PST #7946 of 30001
Remember that the frontier of the Rebellion is everywhere. And even the smallest act of insurrection pushes our lines forward.
Steph L. is not allowed to look at this photo. It has more awesome than she can handle.
sumi - Nov 22, 2011 9:01:09 am PST #7947 of 30001
Art Crawl!!!
Hahahaha!
Allyson - Nov 22, 2011 9:03:40 am PST #7948 of 30001
Wait, is this real-world child support, where the money goes to buy food for the kids, or MRA fantasyland child support where the women just buy Ferraris and cocaine? -Jessica
Recent research suggests that heterosexual men’s (but not heterosexual women’s) cognitive performance is impaired after an interaction with someone of the opposite sex (Karremans et al., 2009)..
I love that Discoblog turns commenting off on these sorts of pieces.
§ ita § - Nov 22, 2011 9:05:40 am PST #7949 of 30001
Well not canonically, no, but this is transformative fiction.
I wonder if gay men are supposed to have issues after interacting with people of the same sex.
Steph L. - Nov 22, 2011 9:18:28 am PST #7950 of 30001
this mess was yours / now your mess is mine
Steph L. is not allowed to look at this photo. It has more awesome than she can handle.
Oh god, the tongue! I am DED.