Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Elements Gallery | Excel Discussion (Misc queries) | |||
Lock Workbook Elements | Excel Discussion (Misc queries) | |||
XML elements in Excel | Excel Discussion (Misc queries) | |||
XML elements in Excel | Excel Discussion (Misc queries) | |||
Protection elements | Excel Discussion (Misc queries) |