Adding Multiple Values

  • Thread starter Thread starter Larry
  • Start date Start date
L

Larry

Is there a short cut to add values other than the following examples:

Every 5th Row - Sum(A1+A6+A11+A16+A21....
Every 3rd Column - Sum(A1+D1+G1+J1+M1....

Thanks
 
How about something like this:

=SUMPRODUCT(A8:A29*(MOD(ROW(A8:A29)-ROW(A8),5)=0))

=SUMPRODUCT(E1:Q1*(MOD(COLUMN(E1:Q1)-COLUMN(E1),3)=0))

Regards,.
KL
 
Every 5th Row - Sum(A1+A6+A11+A16+A21....

Try something like:
=SUMPRODUCT(--(MOD(ROW(A1:A20),5)=1),A1:A20)

Or, for almost the entire column:
=SUMPRODUCT(--(MOD(ROW(A1:A65535),5)=1),A1:A65535)
Every 3rd Column - Sum(A1+D1+G1+J1+M1....
Click to expand...

Try something like:
=SUMPRODUCT(--(MOD(COLUMN(A1:Z1),3)=1),A1:Z1)

Or, for the entire row1:
=SUMPRODUCT(--(MOD(COLUMN(1:1),3)=1),1:1)

Adapt to suit ..
 
First, you don't use SUM as well as +, they do the same thing. Use

=SUM(A1,A6,A11...

or =A1+A6+A11

to get every nth, use

=SUMPRODUCT(--(MOD(ROW(A1:A100),5)=1),A1:A100)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Hi Max,

Yor formulae won't include the first row/column and won't work if not
starting at the first row/column.

Regards,
KL
 
Your formulae won't include the first row/column

But my tests here show that it did and still does (re-checked) ..
and won't work if not starting at the first row/column.
Click to expand...

The suggestions given were on-focus wrt the post,
which indicates clearly the startpoints were from A1 ..
 
Back
Top