| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula to sum non-adjacent cells
Hi Jack,
Supose you data is in column A, you could add in column B this formula : =MOD(ROW(A1),17) Fill down And sum whre the result = 0 =SUMIF(B:B,0,A:A) HTH Regards Jean-Yves "Jack_Feeman" wrote in message ... Excell 2003 I have a 3000+ line spreadsheet with totals in one column every 17th row. What formula can I use to sum these totals? Thanks Jack |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula Omits Adjacent Cells | Excel Worksheet Functions | |||
| Formula omits adjacent cells | Excel Discussion (Misc queries) | |||
| copying adjacent cells with formula | Excel Worksheet Functions | |||
| copying formula into non-adjacent cells, EXCEL2003 | Excel Discussion (Misc queries) | |||
| How can I add non-adjacent cells with a formula | Excel Worksheet Functions | |||
Threaded Mode
