Summing every nth cell

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.
 
L

Leo Heuser

One way:

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

Where N=2, 3, 4, ............
 
F

Frank Kabel

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
Summing Every Nth Cell 12
how do i select every other cell in a column? every nth cell? 5
Unacceptable floating point errors 31
How can I choose every nth name in a spreadsheet? 3
Cond Format nth Column 1
nth row or column counting 1

Top