Formula to sum of every nth row
 

Is there a formula out there that will sum every nth row? I have a template
that has the same measure in consecutive rows and rather than selecting the
cells manually would like to enter a formula.

Thanks for the help.

Go to this page Chip Pearson's site and scroll down to "Summing every nth
value"

http://www.cpearson.com/excel/excelF.htm

hth,

Doug

"ddate" wrote in message
...
Is there a formula out there that will sum every nth row? I have a
template
that has the same measure in consecutive rows and rather than selecting
the
cells manually would like to enter a formula.

Thanks for the help.

=SUMPRODUCT(--(MOD(ROW(B1:B100),n)=m),B1:B100)

where n is the nth row, m is the start point, and should be 0 and <=n-1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ddate" wrote in message
...
Is there a formula out there that will sum every nth row? I have a
template
that has the same measure in consecutive rows and rather than selecting
the
cells manually would like to enter a formula.

Thanks for the help.

ddate wrote:
Is there a formula out there that will sum every nth row? I have a template
that has the same measure in consecutive rows and rather than selecting the
cells manually would like to enter a formula.

Thanks for the help.

See:

http://tinyurl.com/an9t9

Say you want to sum every 3rd row and your data starts from A1 thru A42 the
following will sum every 3rd row

=SUM(IF(MOD(ROW(A1:A42),3)=0,A1:A42))
Array entered (ctrl+shift+enter)

Now changing 3 to 4 in the fomula will sum every 4th row

However be careful with the beginning row number where the sum range begins
as this formula would need tweaking to adopt to that

"ddate" wrote in message
...
Is there a formula out there that will sum every nth row? I have a
template
that has the same measure in consecutive rows and rather than selecting
the
cells manually would like to enter a formula.

Thanks for the help.