i have to add cells evenly spaced, eg a1 + a11+a21+...+a991

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i have to add cells evenly spaced, eg a1 + a11+a21+...+a991
how can I avoid writting all references?
 
Try something like this:

For a list of numbers in Col_A

B1: =SUMPRODUCT((MOD(ROW(A1:A1000),10)=1)*A1:A1000)

Adjust range references to suit your situation.

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro
 
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

How to appy the formular with different cell parameters~kindly hel 2
Link and formula question 1
Sum if two conditions met 3
SUMIF of specified cells in a range 7
loop to copy paste 3
Countif problem 2
populating treeview 2
Formula Help-Excel 2007 2

Back
Top