Forum Discussion
Adding numbers in nonconsecutive cells in a column
I have a column of cells with numbers. I would like to know the formula for getting the sum of the numbers in certain of the cells. Example: The cells go from A1 to A25. I would like to get a sum...
An alternative starting point is, why did you select A1:A12 + A18:A22 for the summation? There must be something about the content over and above an irresistible attraction to the area of worksheet A18:A22.
A common practice is to have a second column to select the cells to sum and have a formula such as
= SUMIFS( rangeA, rangeB, "include me too!" )