A
arek.krawczynski
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
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