Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
=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. |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
Dynamic (?) formula | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |