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))

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))

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))

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))