| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
sum alternate rows
is there a formula that allows you to sum alternate rows (even vs odd) or
similar? Can this be done with a variation of the "sumif" function? anand |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum alternate rows
Don't worry about it. Found it. Please ignore question anand |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum alternate rows
One way ..
In say, B1: =SUMPRODUCT(--(MOD(ROW(A1:A10),2)=1),A1:A10) returns the sum of the odd rows within the range A1:A10, viz the sum of: A1, A3, A5, A7, A9 =SUMPRODUCT(--(MOD(ROW(A1:A10),2)=0),A1:A10) returns the sum of the even rows within the range A1:A10, viz the sum of: A2, A4, A6, A8, A10 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "anand" wrote: is there a formula that allows you to sum alternate rows (even vs odd) or similar? Can this be done with a variation of the "sumif" function? anand |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum alternate rows
To sum cells A1:A7 that are
EVEN: =SUM(IF(MOD(ROW(A1:A7),2)=0,A1:A7,0)) ODD: =SUM(IF(MOD(ROW(A1:A7),2)=1,A1:A7,0)) Ctrl+Shift+Enter to enter formula |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
sum alternate rows
Durn it, too late <g. The shot's fired.
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "anand" wrote: Don't worry about it. Found it. Please ignore question anand |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Printing Alternate Rows | Excel Discussion (Misc queries) | |||
| Summing Alternate Rows | Excel Discussion (Misc queries) | |||
| moving alternate rows | Excel Discussion (Misc queries) | |||
| Add alternate rows | Excel Worksheet Functions | |||
| How to sum-up alternate rows ? | Excel Worksheet Functions | |||
Linear Mode
