/sci/ - Science & Math

File: 75 KB, 917x454, untitled.jpg [View same] [iqdb] [saucenao] [google]

Harriet !x6oGOnISPY Wed Dec 7 03:00:36 2011 No.4110675 [Reply] [Original]

Hello.
If I am making a spreadsheet on Excel, is it possible to write a function on one of the columns that is a cumulative total of all the numbers in the column next to it so far?
How would I go about setting this up?
Thanks.

Picture is not related.
Will try /g/ as well.

>>	Anonymous Wed Dec 7 08:28:07 2011 No.4111290 explain better

>>	Anonymous Wed Dec 7 08:33:47 2011 No.4111298 not science

>>	Anonymous Wed Dec 7 08:48:32 2011 No.4111318 try =sum then click

>>	Harriet !x6oGOnISPY Wed Dec 7 15:05:56 2011 No.4112244 >>4111318 Click on what?

>>	Anonymous Wed Dec 7 15:07:11 2011 No.4112254 yes it is possible. >>4111318 what this guy said click on the column you want it to sum.

>>	Anonymous Wed Dec 7 15:09:20 2011 No.4112269 =SUM(B1:B5) where B1 is the starting value and B5 is the final value or a column.

>>	Anonymous Wed Dec 7 15:10:27 2011 No.4112273 >>4112269 of* a column.

>>	Harriet !x6oGOnISPY Wed Dec 7 15:39:55 2011 No.4112414 >>4112269 Perfect! It was so simple, thank-you for bringing it to my attention. x

>>	Professor Teacup !obkpuSWh5M Wed Dec 7 15:40:04 2011 No.4112419 >>4112414 You're done? Good. Tell EK to take her pills and bye.

>>	GL !Bgpe2HycPk Wed Dec 7 15:41:04 2011 No.4112426 >>4112419 Shut up, Teapot.

>>	Anonymous Wed Dec 7 15:42:19 2011 No.4112432 File: 66 KB, 1054x696, retardedharriet.png [View same] [iqdb] [saucenao] [google] your daily reminder that harriet is retarded and ek is crazy

>>	Professor Teacup !obkpuSWh5M Wed Dec 7 15:43:27 2011 No.4112439 >>4112426 Go suck Blackman's dick, GL (GayLover).

>>	GL !Bgpe2HycPk Wed Dec 7 15:46:43 2011 No.4112450 >>4112432 Your daily reminder that Anonymous is retarded: >>4112431 >>4112439 Don't use rude language here.

>>	Anonymous Wed Dec 7 15:47:51 2011 No.4112454 All of the worst people on the board in one thread.

>>	Anonymous Wed Dec 7 15:48:00 2011 No.4112460 I'd just use B2 = A2 + B1 but I don't trust excel's built-in functions.

>>	Harriet !x6oGOnISPY Wed Dec 7 15:48:00 2011 No.4112461 >>4112419 She knows it is important, and I am sure she takes it at the times requested. >>4112432 How would that make me retarded? EK is not crazy, just unusual.

>>	GL !Bgpe2HycPk Wed Dec 7 15:48:00 2011 No.4112462 >>4112454 And this one is the worst: >>4112454

>>	Harriet !x6oGOnISPY Wed Dec 7 15:49:00 2011 No.4112469 >>4112460 You do not trust? Computer functions can not be in error, only the input can have an error.

>>	Anonymous Wed Dec 7 15:50:07 2011 No.4112471 You guys crack me up while also instilling a fear of finding myself a tripcode

>>	Anonymous Wed Dec 7 15:51:16 2011 No.4112480 >>4112461 because you talked about ek behind her back after you just said that saying she was bipolar made her mad

>>	Harriet !x6oGOnISPY Wed Dec 7 15:52:23 2011 No.4112482 >>4112480 That is not 'retarded', it was perhaps discourteous.

>>	Professor Teacup !obkpuSWh5M Wed Dec 7 16:01:27 2011 No.4112536 >>4112450 Fuck you, just leave. >>4112461 Cr- cr- crazy.

>>	Harriet !x6oGOnISPY Wed Dec 7 16:03:43 2011 No.4112546 >>4112536 She is not crazy, she generally gets along fine in day to day life, and one can not tell that she is even different.

>>	GL !Bgpe2HycPk Wed Dec 7 16:03:43 2011 No.4112545 >>4112536 We should totally meet IRL, Teapot. I think I'm gonna come to Scotland.

>>	Professor Teacup !obkpuSWh5M Wed Dec 7 16:05:59 2011 No.4112560 >>4112545 I DO NOT LIVE IN SCOTLAND. >>4112546 I'm not talking to you until you let bane come out.

>>	Harriet !x6oGOnISPY Wed Dec 7 16:08:15 2011 No.4112572 >>4112560 Are you the same as regular 'Teacup'? If so, why did you change your name? I do not know 'bane'

>>	GL !Bgpe2HycPk Wed Dec 7 16:08:15 2011 No.4112574 >>4112560 Sometimes you live in Scotland, sometimes you don't. Kinda like Schrödinger's cat. Nonetheless I'm gonna find you.

Professor Teacup !obkpuSWh5M Wed Dec 7 16:10:32 2011 No.4112580

>>4112572
I changed my name because my IQ is high according to a test, so I decided to become a professor.

bane is our friend, you know him. He was a tripfriend on /sci/.

>>4112574
Just ask /sci/ for Rose's profile, that'll prove I'm not in Scotland.

>>	Anonymous Wed Dec 7 16:10:32 2011 No.4112583 File: 50 KB, 420x420, r10466_fuck+this+thread+outta+here.jpg [View same] [iqdb] [saucenao] [google]

>>	GL !Bgpe2HycPk Wed Dec 7 16:13:56 2011 No.4112592 >>4112580 Which IQ test did you take?

>>	Harriet !x6oGOnISPY Wed Dec 7 16:14:03 2011 No.4112598 >>4112580 A person is appointed as a professor regardless or IQ; it is not considered. People do not have profiles here; we are anonymous.

>>	Professor Teacup !obkpuSWh5M Wed Dec 7 16:14:03 2011 No.4112599 >>4112592 ...One of those regular ones.

>>	GL !Bgpe2HycPk Wed Dec 7 16:18:27 2011 No.4112615 >>4112599 Depending on where you live imposture can be illegal. Don't know how it is in Scotland.

>>	Professor Teacup !obkpuSWh5M Wed Dec 7 16:22:51 2011 No.4112628 >>4112615 It was one of those online IQ tests, but I'm certain it was accurate, it said so.

>>	GL !Bgpe2HycPk Wed Dec 7 16:23:00 2011 No.4112633 >>4112628 I'm pretty sure all of them are accurate and reliable. Especially those which don't allow you to get an IQ lower than 150.

>>	Professor Teacup !obkpuSWh5M Wed Dec 7 16:24:15 2011 No.4112639 >>4112633 Stop hurting my feelings. The IQ test said I was very special and gifted.

>>	Harriet !x6oGOnISPY Wed Dec 7 16:26:24 2011 No.4112645 >>4112639 Many internet IQ tests on the internet are biased given the fact that people with a low IQ are far less likely to decide to engage in taking the test to completion.

>>	GL !Bgpe2HycPk Wed Dec 7 16:27:31 2011 No.4112649 >>4112639 We all agree that you are special ;)

>>	Stupid !obkpuSWh5M Wed Dec 7 16:28:40 2011 No.4112655 >>4112645 >>4112649 You're calling me stupid? Fine then, I'll be stupid.

>>	GL !Bgpe2HycPk Wed Dec 7 16:29:47 2011 No.4112658 >>4112655 Why not Professor Stupid?

>>	Anonymous Wed Dec 7 16:32:04 2011 No.4112668 >>4112469 http://www.joelonsoftware.com/items/2007/09/26b.html Excel has a long history of subtle bugs. I don't trust it.

>>	Harriet !x6oGOnISPY Wed Dec 7 16:34:20 2011 No.4112675 >>4112655 I did not say that you are stupid, I just do not personally think that an IQ test is supposed to be taken particularly seriously. >>4112668 Thankyou. This is interesting.

>>	Anonymous Wed Dec 7 16:35:27 2011 No.4112683 >>4112655 no please change it to teacunt

Advanced search
Text to find
Subject [?]Search by post subject. Leave empty for any.
Username [?]Search for user name. Leave empty for any user name.
Tripcode [?]Search for tripcode. Leave empty for any.
Email [?]Search by email. Leave empty for any.
Filename [?]Search by image filename. Leave empty for any.
From Date [?]Enter what date to start searching from. Format is YYYY-MM-DD
To Date [?]Enter what date to start searching until. Format is YYYY-MM-DD
Image hash
Search in	All Posts OPs Only
Deleted posts	Show all posts Show only deleted posts Only show non-deleted posts
Internal posts	Show all posts Show only internal posts Show only archived posts
Order	New posts first Old posts first
Capcode	All Posts Only by Users Only by Mods Only by Admins Only by Developers
Results	Posts Threads
Action	[ Simple ]