Sumproduct Formula

S

SJT

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

T. Valko

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.
 
Top