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

Multiple IF Statement in Word 5
Using FIND to highlight text (with dashes) 4
Help with formula 0
Arriving at totals 2
Multiple Criteria Lookup Function 1
Development combinations with exclusion of columns 0
Conditional If/Else statement 2
Help with an Excel macro please? 6

Top