how do i write a formula to add cell contents that are seperated by ten other cells?
K kcarlson Mar 11, 2010 #1 how do i write a formula to add cell contents that are seperated by ten other cells?
O Otto Moehrbach Mar 11, 2010 #2 =A1+L1 If this is not what you want provide more information about what you want to do. HTH Otto
J JLatham Mar 11, 2010 #3 For every nth (as 10th) ROW, see: http://www.ozgrid.com/Excel/sum-every-2nd-nth-cell.htm And covering both nth Row and nth Column is http://www.mcgimpsey.com/excel/formulae/sumeverynth.html
For every nth (as 10th) ROW, see: http://www.ozgrid.com/Excel/sum-every-2nd-nth-cell.htm And covering both nth Row and nth Column is http://www.mcgimpsey.com/excel/formulae/sumeverynth.html
