=SUM(IF(MOD(ROW($A$10:$A$19),$B$20)=0,$A$10:$A$19, 0))

this is an array formula you will need to controll shift enter for it
to work

$B$20 is the Nth value you want

Add every other number input 2 etc.


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=520860