SUM Every Trird Cell In A Row

M

Minitman

Greetings,

I have a series of rows that I sum up in the first column. I did have
them staggered so that I could just use =SUM(B2:CC2) in the first row
and copy it down to the other two rows. Simple.

But when I tried to collect the same data after compressing the bottom
2 row into the 1st row (where there was just blank space) I realized I
haven't a clue as to how that is done!

Anyone have any ideas as to how to get the sum from every third cell?

Any assistance on this question will be greatly appreciated.

-Minitman
 
T

T. Valko

=SUM(B2:CC2)
get the sum from every third cell?
Click to expand...

So, every 3rd cell would be B2, E2, H2, K2, etc?

If you will *never* insert new columns in front of the range:

=SUMPRODUCT(--(MOD(COLUMN(B2:CC2),3)=2),B2:CC2)

If you might insert new columns in front of the range:

=SUMPRODUCT(--(MOD(COLUMN(B2:CC2)-COLUMN(B2),3)=0),B2:CC2)
 
M

Minitman

Hey Biff,

I've not used MOD before and had no idea what it did, now I know.

Thanks.

-Minitman
 

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

SUM Every Thrid Cell In A Row 2
Sum every Nth Row (almost working) 1
Sum automatically every cell in multiple rows 1
sum of every 4th cell in a row. 6
nth row or column counting 1
Automatic update to SUM formula cell references. 6
Circular reference, Indirect, and Sum 3
Offset, sum down to the first blank row 6

Top