LinkBack URL
About LinkBacks
Hi All,
I have a range of data A1:A500 and I'd like to find the sum of every non-consecutive seven cells. For example, I'd like to sum A1:A7 and then sum A8:A14. Can someone please help? Any help would be greatly appreciated. Thanks.
Hi All,
I have a range of data A1:A500 and I'd like to find the sum of every non-consecutive seven cells. For example, I'd like to sum A1:A7 and then sum A8:A14. Can someone please help? Any help would be greatly appreciated. Thanks.
Can you clarify?You say non-consecutive cells, but the ranges you state you wish to sum are indeed consecutive cells.
Hi dschwister and welcome to the forum.
Find the attached with what I think you want. The equation in B1 is:
Please Login or Register to view this content.
Last edited by MarvinP; 10-13-2011 at 01:15 PM.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Originally Posted by brokenbiscuits
I say non-consecutive, because I want to sum A1:A7, and then A8:A14 (not A2:A8). Does that make sense?
Hi dschwister and welcome to the forum.
Find the attached with what I think you want. The equation in B1 is:
Please Login or Register to view this content.
Thanks a lot MarvinP. So, I'm at work and unfortunately don't have MS Excel. I'm relegated to Google Spreadsheets. Are you actually putting a value in the ( ) after ROW?
Without the indirect (but using Arrayed function, enter with CNTRL SHFT ENTER)
=SUM(IF(INT((ROW($A$1:$A$500)-1)/7)+1=ROW(),$A$1:$A$500,))
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
The function "Row()" simply reports back the current row number the formula is in.
I have no idea if Google Docs has this ability or not.
Thanks ChemistB. That unfortunately doesn't work though. That formula just added up my entire column.
What I want to do is add A1:A7 and put that value in B1. Then in B2, I want to add A8:14 and so on. Does this make sense?
Hi dschwister,
I believe my formula does what you want. Do you have a list of functions that Google Doc Spreadsheet supports? I know there are some differences between the two function lists. You know that the Excel Forum will be pro Excel and wonder why you would ever want Google Docs as s substitute. My belief in life is "you get what you pay for".
Okay. Should I have a value between the () then?
Hi - I'm so sorry in that I didn't copy and paste the entire formula. It should be
I've corrected it in the post above.Please Login or Register to view this content.
See if this works instead of that half baked answer I gave before.
This stuff is hard enough without giving partial answers. Forgive me please!
Mine works (In Excel at least), You need to enter it with CNTRL SHFT ENTER instead of just pushing ENTER. You'll see brackets {} appear around the equation if you do it right.
Sorry MarvinP. That still isn't working. Just to clarify, I'd like to take data in column B2:B500 and in C2 sum from B2:B9 and then in C3 sum from B10:B17 and in C4 sum from C18:C25. Does this make sense?Hi - I'm so sorry in that I didn't copy and paste the entire formula. It should be
I've corrected it in the post above.Please Login or Register to view this content.
See if this works instead of that half baked answer I gave before.
This stuff is hard enough without giving partial answers. Forgive me please!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks