View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
ALEX ALEX is offline
external usenet poster
 
Posts: 493
Default Summing Quarters

sorry jeff scratch that i see what you want to do... simply you can enter
=a1+b1+c1+d1 in A2 and that should do it automatically.. and then in in b2
put =e1+f1+g1+h1 and so on ... these will automatically poplulate as numbers
enter your boxes a1thru l1

"Alex" wrote:

It depends on where you want to put the info..
do you want to put the information on another worksheet or on the same
worksheet? also do you want to put the info at the end of all of those
columns or do you want to do put it at the end...in between add a column
between c and d then put a = sign in the column next to the 3 boxes you want
to add, then the reference numbers to those boxes example =a1+b1+c1 press
enter and the box will show the answer. You can then select the box with
your mouse and you will highlight the box (note the box will have a dark
black small box in the bottom right hand corner) grab that little box and
drag to end of column where info is to be added... it will automatically
populate boxes.. let me know if this helps... let me know if you have any
questions

"Jeff" wrote:

Can anyone devise a formula to summarize monthly data by adding each three
months? That is, I need to add columns A-C, D-F, G-I, etc. I've been doing
this manually, but there must be a better way. Thanks.