View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] arek.krawczynski@gmail.com is offline
external usenet poster
 
Posts: 2
Default question about SUM - how to sum each for elements

Hi

I have a problem with function SUM.

I have column A with numbers, and column B where I want to sum
elements from column A by four numbers together. So I put into B:
SUM(A1:A4)
SUM(A5:A8)
SUM(A9:A12)
SUM(A13:A16)
etc...

Is there any chance, to do it automaticly? I tried with everything
what I know. If I simply mark this, and pull down, Excel make it:
SUM(A1:A4)
SUM(A2:A5)
SUM(A3:A6)
SUM(A4:A7)
etc...

I was tring with different adressation $ or without $. But I couldn't
get that result.

I will be happy for any suggestions.
Hamster