sum every forth row

J

john

is it possible to create a formula that will sum every forth cell in a
column? thanks.
 
C

Claus Busch

Hi John,

Am Sat, 10 Oct 2009 05:37:01 -0700 schrieb john:
is it possible to create a formula that will sum every forth cell in a
column? thanks.
Click to expand...

for values in A1:A100:
=SUMPRODUCT((MOD(ROW(1:100),4)=0)*A1:A100)


Mit freundlichen Grüssen
Claus Busch
 

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

Cumulative formula for word table 0
Multiple IF Statement in Word 5
Autonumber field in Excel that behaves the same as Access 0
Opening multiple Notebooks simultaneously in OneNote 2016 for Windows 1
Summing non-consecutive cells 10
Searching for non-consecutive text 3
Pages are changing pasted image... 0
Indenting every other paragraph in Word at the same time? 0

Top