Adding numbers in nonconsecutive cells in a column

Copper Contributor

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 for A1:A12 + A18:A22.  I have tried several variations, all without success.  If someone can tell me the formula I would be very appreciati

5 Replies

@Rchrd1221 Did you try:

=SUM(A1:A12)+SUM(A18:A22)

 

@Rchrd1221 

As variant

=SUM(A1:A12,A18:A22)

@Rchrd1221 

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!" ) 

@Peter Bartholomew 

It very depends on data structure. That could be couple of subtotals inside and =SUBTOTAL(109, A1:A23) as final sum. If in A3:A17 are texts that could be simply =SUM(A1:A22). Perhaps other variants, it depends.

True, but I guess that is something I dislike about spreadsheet solutions and the notation they use. There is no indication of the user-intent so it is difficult to assess the validity of any proposed solution.