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, ............
 
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)
 
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

Sum of every nth cell in a column 3
Summing every Nth row 5
Enter every nth cell item 4
Deleting every nth through every nth row in a column 1
Referencing every nth cell in a new column 1
Copy every nth row 0
how do i select every other cell in a column? every nth cell? 5
copy a value across a row but into every nth cell 4

Top