PSX5Central

Non Gaming Discussions => Off-Topic => Topic started by: ##RaCeR## on December 31, 2003, 11:16:28 PM

Title: How do I do this in Excel?
Post by: ##RaCeR## on December 31, 2003, 11:16:28 PM

I have a whole list of numbers in a cell, for instance, from cell B3 down to cell B20. I want to calculate the total number in each cell.

For instance, I have $50 in B3, $20 in B4, $90 in B5 etc etc etc, how do I get it to count them all, thus B3+B4+B5 = $160?

I remember doing this at school but I forgot!

Title: How do I do this in Excel?
Post by: Coredweller on December 31, 2003, 11:57:43 PM

Select the cell below the column of cells you want to sum.

Click the (https://psx5central.com/community/proxy.php?request=http%3A%2F%2Fgallery.s2ki.com%2Fimagecatalog%2Fimageview%2F102257%2F&hash=2406b6fd3520a170d3f2552ff8e247c405c25973) button on the toolbar, and then hit Enter

Anyway, it\'s the button with the Greek letter Sigma.

Title: How do I do this in Excel?
Post by: GmanJoe on December 31, 2003, 11:59:53 PM

Quote

Originally posted by Coredweller
Select the cell below the column of cells you want to sum.

Click the Ó button on the toolbar, and then hit

Hey dammit! What happened to my $160 I had in my wallet?

Title: How do I do this in Excel?
Post by: ##RaCeR## on January 01, 2004, 12:49:26 AM

Sweet! Thanks guys!

Title: How do I do this in Excel?
Post by: videoholic on January 01, 2004, 04:12:20 AM

=sum(B3:B20)

that\'s all you have to write

I would type "=sum(" and then highlight the cells you want to add

Title: How do I do this in Excel?
Post by: ##RaCeR## on January 01, 2004, 04:56:59 AM

I feel like such an idiot now. Its amazing the things you forget when you haven\'t done em in ages (well like a year...)