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

Advertisements

L

Leo Heuser

One way:

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

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

Advertisements

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
Excel Excel: sum of 7 cells (weeks) in every row of a spreadsheet 1
Trailing 30 days sum calculation with excel 1
nth row or column counting 1
Summing Every Nth Cell 12
Sum every Nth Row (almost working) 1
Cell not calculating after importing data 2
copy a value across a row but into every nth cell 4

Top