LinkBack URL
About LinkBacks
I'm trying to sum every 4th row in a column. I have about 100 rows of data, and need to break it down. Is there a way to select the first, then do a count +1 or something to increment to the next row?
I'm trying to sum every 4th row in a column. I have about 100 rows of data, and need to break it down. Is there a way to select the first, then do a count +1 or something to increment to the next row?
Last edited by dta1984; 11-01-2011 at 05:12 PM.
This formula will sum every 4th row of A2:A100 starting at A2
=SUMPRODUCT(0+(MOD(ROW(A2:A100)-ROW(A2),4)=0),A2:A100)
Audere est facere
Exactly what I needed!! Thanks!Originally Posted by daddylonglegs
Try the array formula
=SUM(IF(MOD(ROW($A$1:$A$48),4)=1,$A$1:$A$48))
For an array formula, enter with CNTRL SHFT ENTER instead of ENTER
This formula will sum rows 1, 5, 9, etc
Substitute = 2 for 2, 6, 10 etc
=0 for 4, 8, 12, etc
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
check attachment
Regards
tom1977
If You are satisfied with my solution click the small star icon on the left to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks