Excel Help

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I am having trouble using offset to sum up every third
column, could someone please explain
 
I am having trouble using offset to sum up every third
column, could someone please explain
Click to expand...

I don't know about using OFFSET, but this formula will:

=SUM(IF(MOD(COLUMN(A1:Z1),3)=0,A1:Z29))

This is an **array** formula so must be entered by holding down <ctrl><shift>
and <enter>.

As written, it will sum c1:c29, f1:f20, i1:i29, etc.

If you want to start at column A, then change the equality to a 1.


--ron
 
Every third column starting from ... where???

A1:X1
A ... D ... G ... etc:
=SUMPRODUCT((MOD(COLUMN(A1:X1)-1,3)=0)*(A1:X1))

A1:X1
B ... E ... H ... etc:
=SUMPRODUCT((MOD(COLUMN(A1:X1)-2,3)=0)*(A1:X1))

A1:X1
C ... F ... I ... etc:
=SUMPRODUCT((MOD(COLUMN(A1:X1),3)=0)*(A1:X1))
 
You must log in or register to reply here.

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

Trailing 30 days sum calculation with excel 1
Numbers showing Up Centered in Cell ? 1
Identifying Last Column With Text 1
Sum of every nth cell in a column 3
What is the "--" (double dash) in MS Excel formula? 2
Macro to Sum Two Adjacent Columns as per Text in previous Column 8
Lotus 123 @nsum function equivalent in excel(?) 10
Sum parts of a column 2

Back
Top