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)
 

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

Top