Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing cell totals across columns
In the same row, I need to sum cell totals across 60 columns. Each
cell total is an equidistant 4 columns to the right of the previous cell total. The formula needs to reside in the same row in the last column after all of the totals. I have tried =sum(offset(A4:mm4,0,4)), but this doesn't work. (It sums the totals, but also adds the data between the cell totals; perhaps I'm not using this formula correctly?). Any suggestions? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing cell totals across columns
=SUMPRODUCT(--(MOD(COLUMN(A4:BM4),4)=1),A4:BM4)
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... In the same row, I need to sum cell totals across 60 columns. Each cell total is an equidistant 4 columns to the right of the previous cell total. The formula needs to reside in the same row in the last column after all of the totals. I have tried =sum(offset(A4:mm4,0,4)), but this doesn't work. (It sums the totals, but also adds the data between the cell totals; perhaps I'm not using this formula correctly?). Any suggestions? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Summing cell totals across columns
Bob,
Thank you! Your recommended formula worked perfectly. -Excelguy- Bob Phillips wrote: =SUMPRODUCT(--(MOD(COLUMN(A4:BM4),4)=1),A4:BM4) -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) wrote in message oups.com... In the same row, I need to sum cell totals across 60 columns. Each cell total is an equidistant 4 columns to the right of the previous cell total. The formula needs to reside in the same row in the last column after all of the totals. I have tried =sum(offset(A4:mm4,0,4)), but this doesn't work. (It sums the totals, but also adds the data between the cell totals; perhaps I'm not using this formula correctly?). Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Summing values incolumns from row cell L7... | Excel Worksheet Functions | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
cell color index comparison | New Users to Excel |