| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sumproduct Formula
I know the following formula is used to sum every 4th column but was
wondering if someone could tell me what the purpose of the column(6:6) is at the beginning of the formula as well as the (6:6) at the end of the formula. Thanks. =SUMPRODUCT((MOD(COLUMN(6:6),4)=1)*(6:6)) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumproduct Formula
what the purpose of the column(6:6) is
It refers to row 6. The formula is summing cells in row 6. A6, E6, I6, M6, Q6 etc. -- Biff Microsoft Excel MVP "SJT" wrote in message ... I know the following formula is used to sum every 4th column but was wondering if someone could tell me what the purpose of the column(6:6) is at the beginning of the formula as well as the (6:6) at the end of the formula. Thanks. =SUMPRODUCT((MOD(COLUMN(6:6),4)=1)*(6:6)) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumproduct Formula
Thank you. "T. Valko" wrote: what the purpose of the column(6:6) is It refers to row 6. The formula is summing cells in row 6. A6, E6, I6, M6, Q6 etc. -- Biff Microsoft Excel MVP "SJT" wrote in message ... I know the following formula is used to sum every 4th column but was wondering if someone could tell me what the purpose of the column(6:6) is at the beginning of the formula as well as the (6:6) at the end of the formula. Thanks. =SUMPRODUCT((MOD(COLUMN(6:6),4)=1)*(6:6)) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sumproduct Formula
You're welcome!
-- Biff Microsoft Excel MVP "SJT" wrote in message ... Thank you. "T. Valko" wrote: what the purpose of the column(6:6) is It refers to row 6. The formula is summing cells in row 6. A6, E6, I6, M6, Q6 etc. -- Biff Microsoft Excel MVP "SJT" wrote in message ... I know the following formula is used to sum every 4th column but was wondering if someone could tell me what the purpose of the column(6:6) is at the beginning of the formula as well as the (6:6) at the end of the formula. Thanks. =SUMPRODUCT((MOD(COLUMN(6:6),4)=1)*(6:6)) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting a sumproduct formula within a sumif formula. | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula | Excel Worksheet Functions | |||
| Help - Looking for a Sumproduct formula | Excel Worksheet Functions | |||
| sumproduct formula | Excel Worksheet Functions | |||
| sumproduct formula | Excel Worksheet Functions | |||
Linear Mode
