| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
summing every other entry in excel
I would like to know how to sum every other entry in a column of numbers.
This is useful to perform numerical intergration. Thanks. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
summing every other entry in excel
Try one of these:
This will sum the odd numbered rows: =SUMPRODUCT(--(MOD(ROW(D7:D17)-ROW(D7),2)=0),D7:D17) This will sum the even numbered rows: =SUMPRODUCT(--(MOD(ROW(D7:D17)-ROW(D7),2)=1),D7:D17) -- Biff Microsoft Excel MVP "physiker" wrote in message ... I would like to know how to sum every other entry in a column of numbers. This is useful to perform numerical intergration. Thanks. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
summing every other entry in excel
Thanks very much. It works great. Small point: I find that the formulas are
reversed; i.e., the first formula sums the even rows (starting with row 1) and the second the odd rows. Thanks again. Physiker "T. Valko" wrote: Try one of these: This will sum the odd numbered rows: =SUMPRODUCT(--(MOD(ROW(D7:D17)-ROW(D7),2)=0),D7:D17) This will sum the even numbered rows: =SUMPRODUCT(--(MOD(ROW(D7:D17)-ROW(D7),2)=1),D7:D17) -- Biff Microsoft Excel MVP "physiker" wrote in message ... I would like to know how to sum every other entry in a column of numbers. This is useful to perform numerical intergration. Thanks. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
summing every other entry in excel
You're welcome!
I find that the formulas are reversed; i.e., the first formula sums the even rows (starting with row 1) and the second the odd rows No, the first formula sums the the odd numbered rows like 1,3,5,7,9. The second formula sums the even numbered rows like 2,4,6,8,10. The formula is using absolute row evaluation. If your range was A2:A13, A2 is an *even numbered row* even though it's the 1st (odd numbered) row *relative* to the range. -- Biff Microsoft Excel MVP "physiker" wrote in message ... Thanks very much. It works great. Small point: I find that the formulas are reversed; i.e., the first formula sums the even rows (starting with row 1) and the second the odd rows. Thanks again. Physiker "T. Valko" wrote: Try one of these: This will sum the odd numbered rows: =SUMPRODUCT(--(MOD(ROW(D7:D17)-ROW(D7),2)=0),D7:D17) This will sum the even numbered rows: =SUMPRODUCT(--(MOD(ROW(D7:D17)-ROW(D7),2)=1),D7:D17) -- Biff Microsoft Excel MVP "physiker" wrote in message ... I would like to know how to sum every other entry in a column of numbers. This is useful to perform numerical intergration. Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Control Data Entry - push entry to next cell | Excel Discussion (Misc queries) | |||
| Auto entry of data based on entry of text in another column or fie | Excel Discussion (Misc queries) | |||
| How do I set up entry box to auto-alphabatize each entry in list? | Excel Discussion (Misc queries) | |||
| PivotTable and summing/not summing | Excel Discussion (Misc queries) | |||
| Cell Entry That Locks Selected Cells From Any Data Entry. | Excel Worksheet Functions | |||
Linear Mode
