Excel will add the curly brackets so that it looks like this: For instance, an array formula to SUM every second cell in the range $A$1:$A$100 could look like this: =SUM(IF(MOD(ROW($A$1:$A$500),2)=0,$A$1:$A$500,0))īecause this is an array formula, you must enter it by pressing Ctrl-Shift-Enter. You can use these functions in numerous ways-some of them producing better results than others. Nest the ROW function within the MOD function (to supply the number argument), divide it by 2 (to sum every second cell), and check to see whether the result is 0 (zero).
The MOD function returns the remainder after number is divided by divisor: MOD( number, divisor) The ROW function returns the row number of a single cell reference: ROW( reference) All these approaches use the ROW function and the MOD function. However, you can accomplish this in a number of different ways.
Excel has no standard function that will sum every nth cell or row.
0 kommentar(er)
