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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sumif based on two variable 4
sumif or sumproduct with a left statement 5
Delete Formula Based on Multiple Columns 1
Sumproduct;3 criteria 5
SUMPRODUCT HELP 2
Copying Formula - Please help 2
OFFSET Formula 5
Problem with SUMPRODUCT formula. 3

Top