|
|
#2
12-18-2012, 01:46 AM
|
|||
|
|||
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 
|
| 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 2010 32bit
Threaded Mode