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...
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.