| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
question about SUM - how to sum each for elements
Try this...
Assume you want the results to appear starting in cell B1. Enter this formula in B1 and copy down as needed: =SUM(OFFSET(A$1,(ROWS(B$1:B1)-1)*4,,4)) B1 will be the sum of A1:A4 B2 will be the sum of A5:A8 B3 will be the sum of A9:A12 B4 will be the sum of A13:A16 etc etc -- Biff Microsoft Excel MVP wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
question about SUM - how to sum each for elements
another way (not so neat as Biff's unfortunately), in A1:
=SUM(INDIRECT("A"&ROW()+3*(ROW()-1)&":A"&ROW()+3*(ROW()))) then copy down HIH On 28 Sty, 07:57, "T. Valko" wrote: Try this... Assume you want the results to appear starting in cell B1. Enter this formula in B1 and copy down as needed: =SUM(OFFSET(A$1,(ROWS(B$1:B1)-1)*4,,4)) B1 will be the sum of A1:A4 B2 will be the sum of A5:A8 B3 will be the sum of A9:A12 B4 will be the sum of A13:A16 etc etc -- Biff Microsoft Excel MVP wrote in message ... 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- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
question about SUM - how to sum each for elements
On 28 Sty, 07:57, "T. Valko" wrote:
Try this... Assume you want the results to appear starting in cell B1. Enter this formula in B1 and copy down as needed: =SUM(OFFSET(A$1,(ROWS(B$1:B1)-1)*4,,4)) B1 will be the sum of A1:A4 B2 will be the sum of A5:A8 B3 will be the sum of A9:A12 B4 will be the sum of A13:A16 etc etc -- Biff Microsoft Excel MVP wrote in message ... 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 Excelent! Thank You both, guys! Can you tell me, where can I find any informations about this solutions? What should I put into google to find some description, becouse I need to use something like this in different functions also. Hamster |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
question about SUM - how to sum each for elements
You're welcome!
As far as where to look for help on formulas... It's hard to be very specific since just about every formula is unique for its application. Here are a couple of websites that have a lot of info on various functions/formulas: http://www.cpearson.com/Excel/MainPage.aspx http://contextures.com/ -- Biff Microsoft Excel MVP wrote in message ... On 28 Sty, 07:57, "T. Valko" wrote: Try this... Assume you want the results to appear starting in cell B1. Enter this formula in B1 and copy down as needed: =SUM(OFFSET(A$1,(ROWS(B$1:B1)-1)*4,,4)) B1 will be the sum of A1:A4 B2 will be the sum of A5:A8 B3 will be the sum of A9:A12 B4 will be the sum of A13:A16 etc etc -- Biff Microsoft Excel MVP wrote in message ... 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 Excelent! Thank You both, guys! Can you tell me, where can I find any informations about this solutions? What should I put into google to find some description, becouse I need to use something like this in different functions also. Hamster |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
question about SUM - how to sum each for elements
welcome
I'd follow Biff's suggestions cause I used sources mentioned by him when I was learning formulae... ;-) On 30 Sty, 22:31, " wrote: On 28 Sty, 07:57, "T. Valko" wrote: Try this... Assume you want the results to appear starting in cell B1. Enter this formula in B1 and copy down as needed: =SUM(OFFSET(A$1,(ROWS(B$1:B1)-1)*4,,4)) B1 will be the sum of A1:A4 B2 will be the sum of A5:A8 B3 will be the sum of A9:A12 B4 will be the sum of A13:A16 etc etc -- Biff Microsoft Excel MVP wrote in message ... 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 Excelent! Thank You both, guys! Can you tell me, where can I find any informations about this solutions? What should I put into google to find some description, becouse I need to use something like this in different functions also. Hamster- Ukryj cytowany tekst - - Pokaż cytowany tekst - |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| 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) | |||
Hybrid Mode
