|
|
#1
12-17-2012, 01:51 PM
|
|||
|
|||
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. 
|
| 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 |
Windows 7 32bit 
Office 2007
Threaded Mode