#1
|
|||
|
|||
Summing Non Contiguous Cells in a Row or Column
I need to total a large number of cells in a column that are not contiguous, ie, not next to each other. For example I want the total of every 4th cell in a column without having to manually entering a formula containing the exact cell references...that would be way to tedious and time consuming. |
#2
|
|||
|
|||
Hi Joe Ottenhof
Two methods assuming data is in A1:A1000: 1/ =SUMPRODUCT(--(MOD(ROW(A1:A1000),4)=0),A1:A1000) 2/ =SUM((MOD(ROW(A1:A1000),4)=0)*(A1:A1000)) This is an array formula: CTRL + SHIFT + ENTER You can change what rows to sum, by changing the MOD part ie: =0 to = 1 or 2 etc Kevin |
#3
|
|||
|
|||
Thanks
Quote:
Thanks very much. The second way works perfectly. The first one gives me an error. I paid a guy $38 and he didn't get the answer...so once again thanks, |
#4
|
|||
|
|||
Sorry Kevin...the first one does work as well. They both work thanks once again.
Joe O |
#5
|
|||
|
|||
Hi Joe
Thanks for the feed back, glad I was of some help. Kevin |
Tags |
indexing, sum alternate cells |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Automatically enter date into a column and make that column read only | Mr Davo | Excel | 1 | 10-29-2012 01:07 AM |
Can I change the horizontal scrollbar to scroll smoothly rather than column by column | carpat | Excel | 0 | 01-10-2012 09:34 AM |
Construct a summary sheet by summing up from one or more than one sheet. | PRADEEPB270 | Excel | 1 | 11-04-2011 03:46 AM |
Count range cells eliminating merge cells | danbenedek | Excel | 0 | 06-15-2010 12:40 AM |
SUMMING TWO COLUMNS | LOGISTICS1 | Excel | 1 | 04-18-2006 06:00 AM |