Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default COnfused about the addtion formula...

I have a ginat list of people going up and down and a lsit of the months from
left to right. My problem is that i would like to add up the monthly numbers.
The ting im confused about is, do i have to make a formuila for each student,
cause that would be 80 times! How can i do this a simpler way???
Thanks in advance
--
"And he was a real happy guy, a real happy guy!"
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default COnfused about the addtion formula...

If you have no gaps in your list, going down, then enter the formula in the
first applicable row. Move yur cursor to the bottom rihgt hand corner, and
you'll notice that the shape of the cursor changes. When this happens,
double click on the mouse, and the formula will copy down to the end. If you
do have gaps in your list, then enter the formula in the forst row. Select
the cell containin the formula, press <Ctrl<C. Select the cell immediately
below this cell, click and keep the mouse button depressed, drag down to the
last cell in the list, and press <Ctr<V to copy it sown.

"Celibonk" wrote:

I have a ginat list of people going up and down and a lsit of the months from
left to right. My problem is that i would like to add up the monthly numbers.
The ting im confused about is, do i have to make a formuila for each student,
cause that would be 80 times! How can i do this a simpler way???
Thanks in advance
--
"And he was a real happy guy, a real happy guy!"

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM
Reusing formula Tony29 Excel Discussion (Misc queries) 7 September 7th 06 03:34 AM
If formula - got myself confused! JoFo Excel Worksheet Functions 5 July 19th 06 10:47 AM
Match then lookup Tenacity Excel Worksheet Functions 9 December 3rd 05 05:30 AM
Formula Problem - interrupted by #VALUE! in other cells!? Ted Excel Worksheet Functions 17 November 25th 05 05:18 PM


All times are GMT +1. The time now is 07:05 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"