Author Topic: How do I do this in Excel? (Read 661 times)

« **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!

« **Reply #1 on:** December 31, 2003, 11:57:43 PM »

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

Click the

button on the toolbar, and then hit Enter

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

GmanJoe · « **Reply #2 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?

« **Reply #3 on:** January 01, 2004, 12:49:26 AM »

Sweet! Thanks guys!

videoholic · « **Reply #4 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

« **Reply #5 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...)

Hello

Author Topic: How do I do this in Excel? (Read 661 times)