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.
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:
=SUM(INDIRECT("A"& 7*(ROW()-1)+1 & ":A" &7*ROW()))
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.
Hi dschwister and welcome to the forum.
Find the attached with what I think you want. The equation in B1 is:
=SUM(INDIRECT("A"& 7*(ROW()-1)+1 & ":A" &7*
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?
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.
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.=SUM(INDIRECT("A"& 7*(ROW()-1)+1 & ":A" &7*ROW()))
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!
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
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".
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks