These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Basic Spreadsheet Help!
Author
Previous Topic Next Topic
Aricaan
Rum and Quafe
#1 - 2012-08-26 18:41:03 UTC
Im using google docs, so not sure how much different it is on other software.

I got a number in B2 cell, and another number in the C2 cell.... I want their sum in the d2 cell...

SUM(D2)=C2*B2

Seems right? Right?

How do I enter this in the D2 cell....

Ive looked up a few you tube vids, and they say go up to insert.. but that function in insert isnt there anymore. Also, googles help files are useless. The only thing I have seemed to get work, is Ill write this formula in another box, and it just checks the math. I dont want my document so much to check it, but actually do the math... ya dig?

Free iskies to the first to help. Thanks.

There was an old mineral calculator I used to use on eve geek, but it seems eve geek has gone away.
Aricaan
Rum and Quafe
#2 - 2012-08-26 19:09:47 UTC
Someone helped me out in Mining Chat... sorry for spam Big smile
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#3 - 2012-08-26 23:07:14 UTC
On the offchance someone comes across this, wanting a similar answer:

=sum(b2,c2)

If you want to sum a bunch of figures

=sum(b2:f2)

will sum everything from b2 to f2


Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Aricaan
Rum and Quafe
#4 - 2012-08-27 02:44:07 UTC
Well actually, I needed to type in my formula in a box on top of the spreadsheet, as opposed to inside the cell, and it worked. Turned out that was my problem.
Sigras
Conglomo
#5 - 2012-08-27 06:59:31 UTC
no, that wasnt the problem.

Picture the cell as a variable, and what you type into the cell is what youre setting the variable to.

you should always start an equation in excel/google docs etc with a "=" there should be nothing left of the "="
Abdiel Kavash
Deep Core Mining Inc.
Caldari State
#6 - 2012-08-27 13:01:14 UTC
Uhh is there anything wrong with simply "=C2 + B2"? Why would you even think of using multiplication when you want to sum up?
Caelis Boirelle
Aurora Investments
#7 - 2012-08-27 13:25:46 UTC  |  Edited by: Caelis Boirelle
Aricaan wrote:
.

SUM(D2)=C2*B2



Err, nope.

SUM(D2)=C2+B2

PRODUCT(D2)=C2*B2

But yeah as has been mentioned previously of you want a cell to give you the sum of two other cells you need to enter it into the particular cell like this:

=SUM(B2:C2)

Or just type =Sum( then select the cells you want and it'll automatically fill with the correct numbers, then close it again with a second ).

Simples!

Aurora Investments is looking for an alliance to call home