Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum every nth cell in a row
Hi
I am trying to adapt Bob Phillips formula =SUMPRODUCT((B2:B32)*(MOD(ROW(B2:B32)-ROW(B2),n)+1=m)) I have cells, e5,e6,e7,e8,e9,e10,e11,e12,e13,e14,e15, etc I want to sum, e5,e9,e13 etc I will need to adapt this in another cell to add, e6,e10,e14 etc and therefore need to understand the N + M value I have entered the formula below in cell c5, but get 0. Have entered as array formula {=SUMPRODUCT((E5:AY5)*(MOD(ROW(E5:AY5)-ROW(B2),4)+1=F5))} What am I doing wrong Help appriciated Brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200803/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
sum every nth cell in a row
I have used this formula for summing up the 3rd row.
=SUM(IF(MOD(ROW($O$3:$O$425),$O$435)=0,$O$3:$O$425 ,0)) Cell O435's value is 3 in this case. So it takes the sum of the cell if the remainder or the row# divided by 3 (cell O435) of the is equal to 0. You should be able to use this and assign an unused cell to 4, and use that as your divisor. and you can change the =0 to be anything between 0 and 1 number less than you are using as you divisor. Hope this helps. "BNT1 via OfficeKB.com" wrote: Hi I am trying to adapt Bob Phillips formula =SUMPRODUCT((B2:B32)*(MOD(ROW(B2:B32)-ROW(B2),n)+1=m)) I have cells, e5,e6,e7,e8,e9,e10,e11,e12,e13,e14,e15, etc I want to sum, e5,e9,e13 etc I will need to adapt this in another cell to add, e6,e10,e14 etc and therefore need to understand the N + M value I have entered the formula below in cell c5, but get 0. Have entered as array formula {=SUMPRODUCT((E5:AY5)*(MOD(ROW(E5:AY5)-ROW(B2),4)+1=F5))} What am I doing wrong Help appriciated Brian -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200803/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
NEED VBA TO SELECT A CELL; NOTE THE CELL VALUE;COPYADJ CELL;FIND CELL VALUE IN A RANGE AND SO ON | Excel Programming | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) |