Summing every nth cell

  • Thread starter Thread starter S. Neese
  • Start date Start date
S

S. Neese

Is there some way to tell Excel to sum (or whatever
calculation) every nth cell in a column?

I'd be most appreciative of any suggestions.
 
One way:

=SUMPRODUCT((B3:B20)*(MOD(ROW(B3:B20)-ROW(B3),N)=0))

Where N=2, 3, 4, ............
 
Hi
try the following (to sum every third cell in A1:A100)
=SUMPRODUCT(--(MOD(ROW(A1:A100)-1,3)=0),A1:A100)
 

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 of every nth cell in a column 3
copy a value across a row but into every nth cell 4
how do i select every other cell in a column? every nth cell? 5
cell selection code 6
Lookup nth entry 2
Unacceptable floating point errors 31
Summing Every Nth Cell 12
How can I choose every nth name in a spreadsheet? 3

Back
Top